From: Simon on
I have a form that is based on a query that shows all the products i
sell, I have a Searhc box that lets me type in a product name then i
button that requerys to display the correct prodcuts. This works fine,
However when i load the form it shows all the products in the form, is
there a way not for it to display the products on open and only shows
when when i clcik the search button

From: Duane Hookom on
You start with a default of "<< enter product here >>" in the search box so
there are no matches.

If you are still lost, perhaps you should tell us how you use the Search
box. We can't see your code or SQL from our vantage point.

--
Duane Hookom
MS Access MVP


"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:bd958e51-86c4-4990-8035-4aef791df5aa(a)q30g2000yqd.googlegroups.com...
> I have a form that is based on a query that shows all the products i
> sell, I have a Searhc box that lets me type in a product name then i
> button that requerys to display the correct prodcuts. This works fine,
> However when i load the form it shows all the products in the form, is
> there a way not for it to display the products on open and only shows
> when when i clcik the search button
>
 | 
Pages: 1
Prev: traduction
Next: Rename a Report and send email