Two forms using one query

[robbeh]

I have a database that has a full search form with 10+ fields. It displays a query results form based on the data entered into the text boxes.

It works pretty good (small issue I am exploring in another thread). My question is, I am also creating a form with a quick search for one of the fields. My question is, can I use the same query with 2 different forms.



Essentially my code in the query builder looks like:

Forms!frmMenu!txtQuickSearch Or Forms!frmFullSearch!txtAccountNumber

The problem is, if I use the quick search I get the dialog popup to enter the data for the full search. However, if I go to the full search it works fine.

Any ideas what is going wrong? Is this even possible?

Thanks!

[June7]

Does this query have dynamic parameters that reference the 10+ textboxes? If the form is not open and available then the query will do popups.

I never use dynamic parameters in queries. I use VBA code to construct filter criteria and apply to form Filter property.

Instead of form RecordSource referencing a query object, can put SQL statement in the RecordSource.

[robbeh]

Thanks June,

That is the case then, the form is not loaded or active so it's popping up. When the full search loads, the quick search is still loaded, just set to visible=false.

I am going to look into using the VBA to construct queries. I am relatively green in Access but feel that learning more VBA/SQL is going to be very benificial going forward.

I will post back here if I have any questions but first I am going to try it on my own.

[June7]

Example of code to build filter criteria http://allenbrowne.com/ser-62code.html

[robbeh]

Example of code to build filter criteria http://allenbrowne.com/ser-62code.html

I don't know a ton of VBA but man that has to be the best commented/newbie friendly code I have ever seen. Learned a ton. Applied to two text boxes without a hitch. Will now try the whole form.

Thanks June7