S
Simon
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
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