Help!.....Query by Form

[JimUK]

here's what i'm trying to do. I have a table (Table1) and what I'm trying to do is use a form (SearchForm) that would call a query. This form needs to have multiple fields that it can query from by hitting a submit button or similiar. I could do a bunch of separate select queries but would like to be able to have the user type in the fields in the form (any that he wanted to search with) the rest should all be wildcarded, and call a query that will display results of search in another canned form that I have. How would I go about doing this. Any help greatly appreciated.


Jim

 

[JimUK]

I'll try to be more specific here. I am putting together a Trouble Report database (Table1) and need to have users search for specific records using the following fields from (Table1), etrnum, equip, date_open, date_closed and problem (which is a memo field). I have a form (SearchForm) created that has just these fields in it and need a query that will search one or all of these fields (user should be able to input to one or more fields in (SearchForm) ordered by etrnum.

I think that I should use a query by Form but am having a hard time coming up with a function or macro that will do the job.

Thanks again.

Jim

 

[braindead2]

This may be what you have in mind

http://www.mvps.org/access/forms/frm0045.htm

if not the code may help you out

 

[stinnes]

Braindead2: the form from mvps.org is dynamite! Thanks for posting it.