if Form is closed ignore Query criteria

[quicova]

Hi everyone.

I have 1 query used in two identical forms.
All the comboboxs of both forms are the same, and used as criteria for the query



but If i have one of the forms closed I get a pop out box asking for the criteria value of the closed form.

It is also happening when I add that form to a navigation form. Every time I switch from form to form it pops out the criteria window.

on the criteria I'm using Like "*" & [Forms]![MyForm1]![combo1] & "*"

Any idea on how to ignore the criteria pop out box?
Thanks so much

[June7]

Not with a dynamic parameterized query. That is one of their drawbacks and one reason I don't use. I use VBA to set form and report filters. I think macros have equivalent.

Why do you have two identical forms? Each form will need its own query. Can construct query directly in the RecordSource property, doesn't have to be reference to saved query object.

Is this a web database?

I don't use or like navigation forms because they seem to make this sort of code really hard if not impossible.

Check if form is loaded:
If CurrentProject.AllForms("form name").IsLoaded Then

[quicova]

It is hard to explain why 2 forms.
basically on is to add items to a list, the other is to edit those item.
If I knew more about access for sure I think you could just use one form. but this will also work.
It is a huge fail that you can't ignore those errors.

Yeah I think the nav form will suck, but I don't see any other why. I cant having the user using the normal navigation window.
If I can't fix this one, the Nav form will not work and I'm screwed.

you saying to put that if statement in the criteria on the query?

[June7]

No, that If statement is VBA code. Not really relevant to your issue and I probably should not have posted it.

A single form should work for both new records as well as to edit existing.

Users should never interact with the Navigation pane but a navigation form does not prevent users getting to navigation pane. Normal forms and code (macro or VBA) can offer similar interface as navigation form but easier to code.