Donald Whittemore
asked on
Access form start problem
I have an Access 2010 database. The primary form was named Main. Due to upcoming enhancements I changed the name of the form to Cards. I have gone through all the VB code and changed references to Main to Cards. There are 6 unbound fields on the form that are used as search arguments.
When I start the application I get 6 Enter Parameter Value boxes. One for each of the search fields. One of the names being displayed is Forms!Main!txtSearchM. txtSearchM is one of the search fields on the form.
How to I change the value being asked for to Forms!Cards!txtSearchM which should then stop the Enter Parameter Value boxes from being displayed on startup?
When I start the application I get 6 Enter Parameter Value boxes. One for each of the search fields. One of the names being displayed is Forms!Main!txtSearchM. txtSearchM is one of the search fields on the form.
How to I change the value being asked for to Forms!Cards!txtSearchM which should then stop the Enter Parameter Value boxes from being displayed on startup?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tool worked great. It was staring me in the face! There was a query called qrySearch that had the form name hard coded.
Many thanks.
Many thanks.
ASKER
I was getting the popup boxes even before the form opened. No code was being executed yet. I don't understand why the query named qrySearch was being activated before the form loaded. It could have been Access doing some kind of preliminary error checking.
Do you have an Autoexec macro?
Or another startup form that might have code that calls the query?
Or another startup form that might have code that calls the query?
ASKER
There is a subform on the main form. Its record source was the query in question.
Run the code and step to the lines where it builds the search criteria.
Change the names as required.