I was getting an Enter Parameter Value error when it would open some of the subforms because I had them pulling information off their parent form automatically when they opened. I solved the issue by opening the forms in Design View, along with being hidden. Now they scan without throwing the missing perimeter errors.
If Not WasFormOpen Then DoCmd.OpenForm FormName, acDesign, , , , acHidden
Yeah, that's a great idea. Since we're only scanning the Controls collection and don't need to read any actual form data, opening the form in Design View avoids those Enter Parameter Value prompts from expressions that depend on the parent form.
Using acDesign with acHidden is a nice clean solution for this utility.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Developer 61.
