Open form without preloading data 1

[hpl2001]

Hello:

Is it possible to open a form without preloading the data? I don't want the query to run until the user clicks on a search button.

TIA

Holly

 

[dhookom]

Your form's record source can be set to return no records. When the search button is clicked, reset the record source.

Duane
Hook'D on Access
MS Access MVP

 

[hpl2001]

Great. Would you be able to show me what the code would look like to reset the record source? The source is a query.

 

[dhookom]

Your record source could be set to something like:
SELECT * FROM [YourQueryNameHere] WHERE 1 = 2;

Then when you are ready, change the record source to something like:
SELECT * FROM [YourQueryNameHere];

You can also open the form with a filter like:
[MyNeverNegativeField] = -1



Duane
Hook'D on Access
MS Access MVP

 

[hpl2001]

That works great. Thank you so much!

Holly