Find hidden reference on a form

Every time I open a certain form a message comes up asking for "Qualification_Title" .
The source for the form is a query, which opens on itself without any problem and when I ignore the request the form opens and displays all the fields.
Somewhere on the form there must be something asking for this "Qualification_Title".
How can I find out where that is.
Can I search the complete form in a way?
I use Access 2010
Fritz PaulAsked:
Who is Participating?
 
SimonCommented:
Check for renamed controls, fields or aliases (i.e. the control on the form is looking for 'Qualification_Title' whereas the column in the query has been aliased to 'Qualification Title')
Check that the query doesn't have any parameters. - view in SQL and check the first line.

Best way I've found to address this type of issue is to think about which items on the form might need a data item like 'Qualification_title' - it could be a textbox control, a combo or listbox that uses it to build the list, a concatenated value in a calculated control, in the master<->child link that relates a subform to the main form...
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Check the forms Order and Filter properties (and in Reports, Sorting and grouping) as well.

As for a find utility:

www.rickworld.com

Best money you'll ever spend.

Jim.
0
 
Fritz PaulAuthor Commented:
Thanks for the teamwork. That covered everything and I found my error.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.