Prev: Crosstab Query - Multiple Value Responses
Next: I also need to ajust the length of fields
From: Simon on 14 Apr 2010 17:13
I have a form with sub form on it

I use this form to search for products we keep in stock with prices, I
have a Search text box on the form then i type in the product then hit
the search button and it requerys the sub form

Only problem i have is when i first load the form it show every
product in the subform, so takes a long time to load

Is there a way to load the page with out the date then i can type in
product i want to search for then it displays the products
From: Jeff Boyce on 14 Apr 2010 19:23
Simon

What about setting the .RecordSource property of that form (?subform) to ""
in the OnLoad event, then re-set it to the proper query after selection...?

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Simon" <S.Dickson(a)shos.co.uk> wrote in message
news:af535f81-8fad-4c48-bb2b-ed562d8f2d8a(a)x12g2000yqx.googlegroups.com...
>I have a form with sub form on it
>
> I use this form to search for products we keep in stock with prices, I
> have a Search text box on the form then i type in the product then hit
> the search button and it requerys the sub form
>
> Only problem i have is when i first load the form it show every
> product in the subform, so takes a long time to load
>
> Is there a way to load the page with out the date then i can type in
> product i want to search for then it displays the products


 | 
Pages: 1
Prev: Crosstab Query - Multiple Value Responses
Next: I also need to ajust the length of fields