Typing into a text box to get query information

[RSW]

Hello everyone,

I'd like to build a database front-end that allows the user to type data into a text box, and then receive (hopefully on the same page) some data related to that entry (from a pretty complicated query).

I already have the query done, but I can't figure out the best way to set up the form. Although I'm still an Access novice, I've seen plenty of form/subform examples with record selectors in each section, but that's not what I want. Because of the number of records that would be involved, I want to make sure the users can just enter the key data manually (and it would be nice if they could use wildcards in it).

I could probably figure out how to set up a page where the default little Enter Parameter Value box would come up first...but I'd like something more professional-looking than that.

Does anyone have an idea of how best to set up this sort of page?


Thanks in advance!

 

[rainman89]

look through this forum for a search form.. you will find many posts on them.


Also you can use LIKE to get the wild cards you were speaking of.

 

[RSW]

Thanks...I have done search boxes before, but in this case I'd really like for the data to be input before any query is even run or any data is displayed.

 

[rainman89]

You can hide the subform until you enter something into the textbox... This way it looks like there is no data, but there actually is.