How do I create a dynamic Query?

[PithPossium]

I'm new to Access. I've created a table called contacts that has the common fields for contacts (eg. FName, LName, Address ....)

I want to creat a form in which our Admin Assistant can Search by Last Name, Title, or Comapny. I need to know how to Query the table with the fields in the Form.

The Form is called SearchForm and the textboxes are called LName, Title, and Company.

I'm not asking for a complete solution. But it would be very helpful is someone could give me a start in the right direction.

Thanks,

Pith

 

[Databaseguy]

Your form will have two parts. The top part will include your search fields, and the text boxes will be unbound.

The bottom part of the form will be a sub-form, based on a parameter query.

The paramater query will contain the criteria. In the Fname field, your criteria will be like "*" & [forms].[yourformname].[yourunboundtextbox1] & "*". The same holds true for any additional fields.

Your form will also have one command button. It's code will be:

Me.Requery

That's it !!! Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy