not load all products on form

[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

 

[John W. Vinson]

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

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.

 

[arlene ramirez]

subed going to jail

 

[arlene ramirez]

subed going to jail

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

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.