not load all products on form

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

I have a form based on a query that dispaly all the products that we
sell, i also have a search text field to search for products that all
works fine

The problem is as there is lots of product it takes a long time to
load the form, is there a way to load the form and not load any data,
then when i type in the search text field and press the button it will
then displace the search query results
 
I have a form based on a query that dispaly all the products that we
sell, i also have a search text field to search for products that all
works fine

The problem is as there is lots of product it takes a long time to
load the form, is there a way to load the form and not load any data,
then when i type in the search text field and press the button it will
then displace the search query results
Click to expand...

Could you post your search button code? If it just changes the Filter property
of the form, you could start with a filter which returns no records, e.g.

[ProductID] = -987654321

and override that filter in the search button.
 
subed going to jail
John W. Vinson said:
I have a form based on a query that dispaly all the products that we
sell, i also have a search text field to search for products that all
works fine

The problem is as there is lots of product it takes a long time to
load the form, is there a way to load the form and not load any data,
then when i type in the search text field and press the button it will
then displace the search query results
Click to expand...

Could you post your search button code? If it just changes the Filter property
of the form, you could start with a filter which returns no records, e.g.

[ProductID] = -987654321

and override that filter in the search button.
Click to expand...
 
Back
Top