Query Quandary

[FoeHunter]

I have a query that uses a criteria similar to the one below. The only downside to this is that I have to have the “SearchForm” open in the background while the rest of the code that opens/closes the query then opens the form runs.

Would it be possible to have the search criteria be saved as a global variable or is an all-too-common example where I have made things more difficult than need be by choosing the more troublesome path?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>

[FONT=Times New Roman]Like "*" & [forms]![SearchForm].[QNSN1] & "*"[/FONT]

 

[revans]

Is it possible? Yes. It wouldn't need to be "global" it could be a private variable. Either way you would have to have code that populates that variable. You would then have to have a function that returns that variable for your query to work--queries can't reference the global (or private whichever) variable directly.

I have done something similar when I have multiple complicated search forms that use similar queries. I call the function from the query which then looks to see which form is open rather than a specific form as I don't know which form would be open until runtime.

hth,

Rich

 

[FoeHunter]

That does help. I'll play around with it and google to see if I can figure something out.

Thanks again.