Pulling multiple criteria from a table with text boxes or combo bo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to figure out how to create a form with text boxes where users can
input specific data, (anywhere from 1 - 4 criteria....I.E...Date, Name,
Location, etc.), hit a button, and display the results.

I'm able to do this with multiple queries where I set the values they query
on and then they choose which query they want. I'd like to make it more
specific to their needs and one form where they could enter the criteria
would be great.

Thanks.
 
The easiest way is to just do a filter by form. You can create a custom
toolbar for the form that has the filter by form icon on it and the filter
icon.

When they press the filter by form icon, Access gives them a copy of the
form with all fields blank (empty). They then enter into the form those
values they want to search on. They can enter only 1 field, or multiple
fields, or all fields depending on what they want.

When they then hit the filter command (icon on the command bar), Access
filters the recordset on which the form is based (i.e., the recordsource)
and displays in the form only those records that meet the filter criteria.

Hitting the filter button a second time clears the filter so that all
records can be displayed.
 
Back
Top