• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 406
  • Last Modified:

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?
0
IBMJunkman
Asked:
IBMJunkman
  • 3
  • 2
1 Solution
 
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
 
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
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
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
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now