How do i set up this Query NEW USER!!

[dywaynewatkins]

I have Six Fields that i want to have on a form for a user to enter in all known fields and return all matches.

I want it to where i can have these fields on a form
FirstName
LastName
BusinessName
PrimSiteNum
Address
City
Once the user has entered all they know i want to hit a button and then at that time run the query in a sub form on the same page returning all matches to the info input.
But if the user does not put in any info in a field i dont want that field searched for.
NEW USER HERE PLEASE HELP AS MUCH AS POSSIBLE

THANKS IN ADVANCE

 

[JeremyNYC]

Check out the Filter By Form feature. It's built in to Access, and it will do exactly what you need.

To use this feature, make a form to show all of those fields. Then click on Records|Filter|Filter By Form.

Check it out, it's pretty sweet.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.