I have recently changed a database (that I did not originally create) to store a new piece of information, and I simply removed an outdated field in the main table and added the new field in its place. When I open one of the forms, it asks for the parameter value for "Reports.Old Log Number"(which is the field I removed for the new FR Number). I have read the posts regarding similar issues with parameter prompts, and have therefore tried everything I can think of to rectify a possible field/object referencing problem (double-checked forms, queries, etc.). I have only been doing this a few months, so there is a big possibility I have missed something completely obvious to the more experienced. Any suggestions are very welcome. Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
parameter prompt
- Thread starter gte118f
- Start date
SydneyGeek
MrExcel MVP
- Joined
- Aug 5, 2003
- Messages
- 12,251
There's a few places to look -- parameter prompts can drive you crazy!
1. Check the form's RecordSource. It's either the table that contains the offending field or a query that references it. If you're like me and build queries on queries, you may have to dig a few levels down.
2. If not, it's probably (part of) the RecordSource for one or more controls on the form -- either a Combo or ListBox, or a (hidden) textbox.
Hope that helps
Denis
1. Check the form's RecordSource. It's either the table that contains the offending field or a query that references it. If you're like me and build queries on queries, you may have to dig a few levels down.
2. If not, it's probably (part of) the RecordSource for one or more controls on the form -- either a Combo or ListBox, or a (hidden) textbox.
Hope that helps
Denis
Upvote
0
Similar threads
- Question
