Filtering a form using selection of a combo box on a another form (user ID)

[ken90004]

I have this small database I am converting from A97 to A2010. I created a new A2010 db and pulled over objects I needed. Everything is tested out and working fine.

I also added a drop down box to the main switchboard to select a "user". Its purpose is so the filter through all the records and pull up only the list of drawing # for that specific drafter.

So I have a table called tblSign_In which has UID auto number, and the employees name. This will be the user names for the drop down of the Main Switchboard.

I have a table called SHEET LIST that list all the data I need to display. This will end up holding tens of thousands of records of information about drawing. I added to this table a field called the LogInID field (UID) to link back to the tblSign_IN, and the correct number and combination.

I also have a query called qrySHEET LIST which selects all SHEET TABLE and inner joins to the tblSign_IN to pull the Employee Name linking on a LogInID field.

What I was trying to do is filter SHEET LIST form (my output form) by the user selected on the MAIN SWITCH form in the drop down box I called cboSignInEmployeeName.

For example:
Sheet List (tbl) might contain information like: Sheet# 22a6; description Dryer; build hours:12; drafter #4.

qrySHEET LIST (also my ouptut data) is pulling all the above, but replace 4 with actual drafter’s name, John Smith

To filter, I have two methods:

The query is my record source for my form SHEET LIST, so I added

WHERE (((tblSIGN_IN.[Employee Name])=[Forms]![MAIN SWITCHBOARD]![cboSignInEmployeeName]));

This prompts me to enter: Forms!MAIN SWITCHBOARD!cboSignInEmployeeName

I removed that, went into the forms property:

Change Filter on Load to Yes, and
added [Forms]![MAIN SWITCHBOARD]![cboSignInEmployeeName]
but again I am prompted to enter a value.

I also tried to play with VBA coding, but skill is limited in that matter, so I really had no idea what I was doing.

[zmbd]

We see this question a lot so there are few articles that should help guide you:
-filtering-
Microsoft Access / VBA Insights Sitemap
42.Cascaded Form Filtering
55.Multiple Combobox Filter with Clear Option
168.Example Filtering on a Form.

If you get bogged down in these please don't hesitate to post back

BTW: You should also take note of the following:
A Tutorial for Access

Database Normalization and Table Structures.

>Posting Guidelines
> How to ask good questions
> FAQ
> Before Posting (VBA or SQL) Code