I have a form based on a query that i use to search for product in my
database, on the form i have text box to type in, then a button to
requery

the query has the following     Like "*" & [forms]![frmProductList]!
[txtProductSearch] & "*"

This query works fine but when i load up the form is shows all the
products we stock which is a lot and seems to take a lot longer to
load now, Is there a way for the form not to load up any data until o
press the search button

Try putting a default in [forms]![frmProductList]![txtProductSearch] that 
would not produce any results.   Something like 'ZZZZZZZZZZZZZZZ'.
-- 
Build a little, test a little.


"Simon" wrote:

> I have a form based on a query that i use to search for product in my
> database, on the form i have text box to type in, then a button to
> requery
> 
> the query has the following     Like "*" & [forms]![frmProductList]!
> [txtProductSearch] & "*"
> 
> This query works fine but when i load up the form is shows all the
> products we stock which is a lot and seems to take a lot longer to
> load now, Is there a way for the form not to load up any data until o
> press the search button
> 
> .
>