Filter Form Records Using Existing Query

[dylankirs]

Hi. Apologies for any incorrect/off technical lingo. Fairly new to Access and would appreciate any help!

I'm trying to create a command button that will filter form records based on an already created query.

I have a main form with 100 records. Each form record is an employee at a company. The main form was created from a table of the 100 employees and shows general employee information. The main form also holds four subforms. The four subforms are questionnaires on various topics.

I created a query that narrows down the employees that have not taken questionnaire #1 (10 employees).

I've tried the following and neither work for me:
DoCmd.OpenForm "MainFormName", acNormal, "QueryName"

DoCmd.ApplyFilter "QueryName"

Interesting enough, I've created a test query using fields ONLY from the main employee table (which the main form was created from), created a test command button using the code above, and the form records filter as expected.

The missing questionnaire query mentioned above was created using fields from BOTH the main employee table and the table that holds the results of questionnaire #1 (with EmployeeID as the link). Think this might be the issue.

How do I create a button that will filter the main form records to show only those 10 records/employees in my query?

Thanks in advance!!

[cactusdata]

Use this code in the OnClick event of the button, where ID is the primary key of the table and YourQuery is the name of your narrowed-down query:

Me.Filter = "ID In (Select ID From YourQuery)"
Me.FilterOn = True

[dylankirs]

Thank you!!! This worked perfectly. Really appreciate the help.

[cactusdata]

Great. You are welcome!