Load query with outdata until search

[Simon]

I have a form with sub form on it

I use this form to search for products we keep in stock with prices, I
have a Search text box on the form then i type in the product then hit
the search button and it requerys the sub form

Only problem i have is when i first load the form it show every
product in the subform, so takes a long time to load

Is there a way to load the page with out the date then i can type in
product i want to search for then it displays the products

 

[Jeff Boyce]

Simon

What about setting the .RecordSource property of that form (?subform) to ""
in the OnLoad event, then re-set it to the proper query after selection...?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.