"Enter Parameter Value" Question

[Saberan]

I have a form (FormSpec) that is filtered by the selection made from a combo box on another form (FormSelect). This works but I've now been asked to make a special section (FormBoss) in the database to allow quick access to certain forms and reports (FormSpec being one). Ultimately my question is can a forms filter property look for a field value on FormSpec, and if its not available, look for a value on FormBoss without having the "Enter Parameter Value" window come up?

 

[Micron]

You would have to try to get the value you want first by testing if the form is open, and if not, see if the other form is open. If not, not sure what you want to do at that point - maybe terminate or supply a default value? You'd have to say what's prompting the parameter dialog (query/code?) to give me a clue as to what you're doing, so some elaboration is needed. If it's a query, you might be able to return the value to the query by using a function call as criteria. If you are opening a form and applying a filter, the same sort of function can pass the value to the opening form via the DoCmd.OpenForm statement. To try to get a value from an open form:

If currentproject.allforms(nameOfForm).IsLoaded Then someVariable = Forms!nameOfForm.ControlName

You would construct an If block to deal with a hierarchy of form choices. Note: I presume you know you cannot literally use what I wrote.