May 8 2012, 11:56 AM
I have cloned a database to use the same basic template.
I changes out the table and form names and everything is working fine outside of when trying to open the form.
When I go to open the form I am getting 3 pop up "Enter Parameter Value" boxes and they are all for fields or forms that have either been renamed or deleted. I tried going into the VB code and I have made sure that everything in there is named correctly. I just can't seem to get these boxes to stop popping up.
May 8 2012, 12:00 PM
When Access can't find a field it believes should (still) be there, it throws a parameter prompt.
My guess is that controls on your form, or the underlying query(ies) for the form/controls contain some of those fields you eliminated.
May 8 2012, 12:01 PM
This is often very hard to track down. The reason you are getting those prompts is because some expression on the form or maybe a sort order, is still referencing the old names. So, in addition to checking all the controls and VBA you have to look at all the controlsources, rowsources, recordsources, sorts, filters, etc. that may still be referencing the old names.
May 8 2012, 12:52 PM
Took a bit but I finally found a hidden query that I needed to update! All works well now!
Thanks for your help
May 8 2012, 02:29 PM
Glad to help
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here