Search form - showing all records

[NewShoes]

Hey all,

I am building a search form in my DB. I have got this working by using a text search box on the main form which then links to a subform that shows the results. This works great, however, when the form is first opened, it shows all the records that be searched. Is there any way that I can stop this? I just want the subform to be blank until a search is ran.

Many thanks for any help!
NS

 

[CazB]

There are probably better ways of doing it, but you could make the subform invisible until criteria is entered?

 

[Poppa Smurf]

Hide your subform when the form opens. Then display the subform after the search.

 

[NewShoes]

Thanks for the suggestions folks. Is this the best solution? How would I go about doing this?

Thanks,
-NS