Using queries to filter records on Form

[adibakale]

I am fairly new to Access and databases and I have been tasked with creating a database for the department I work in.

We import records once a week and users need to go through these records to review them and add notes, make updates, etc.

I need to add a few options to filter which records each employee will be looking at. So far, I have create different command buttons that are attached to different queries using the ApplyFilter method.

This seems to work, however the queries have Criteria and there is a Parameter Prompt each time one of these buttons is clicked.

What I need to know is, How can I disable or bypass the parameter prompt? Or is there a way to automatically input parameters into the form?

Is there a better way to apply filters to the records so the user can select multiple filters?

I am using a single main form to show the record information.

Thanks