search form not to load all data up to start with

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
 
K

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top