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?
IBMJunkmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dale FyeCommented:
The key is finding where the Main form textboxes are referenced in your application.  This can be extremely difficult and time consuming, as they can be embedded in queries, in properties of controls, and what not.

The best tool I've found for finding these references is Rick Fishers "Find and Replace"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hnasrCommented:
Place a break point in the code of the search button.
Run the code and step to the lines where it builds the search criteria.
Change the names as required.
0
IBMJunkmanAuthor Commented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

IBMJunkmanAuthor Commented:
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.
0
Dale FyeCommented:
Do you have an Autoexec macro?

Or another startup form that might have code that calls the query?
0
IBMJunkmanAuthor Commented:
There is a subform on the main form.  Its record source was the query in question.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.

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.