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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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.