search form not to load all data up to start with

  • Thread starter Thread starter Simon
  • Start date Start date
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
 
Try putting a default in [forms]![frmProductList]![txtProductSearch] that
would not produce any results. Something like 'ZZZZZZZZZZZZZZZ'.
 
Back
Top