Urgent: How to use a combo box to filter a table

[roshani007]

Hello Everyone,
I am back with another question about Access 2010.
I would like to filter a table by using a como box.
I researched on internet a found a few solutions which did not work for me.

I have several columns in the table, and I would like to filter them by their departments (there are several users in each department)

I have tried using the combo box wizard and select " I would like to search records based on the values in combo box" but the problem is that the department shows up as many times as it is in that table.

I came across another solution which was to create an unbound combo box and link it with the query. and the department criteria would be the following:


[Form]![NameOfTheForm]![NameOfTheCombobox]
but it did not work either.


Please help me with this. I have this project due on thursday and this is one to the last things I need to complete. Any help will be appreciated.

Thank you so much in advance.

Roshni

[pbaldy]

I would expect the second to work but there's an "s":

[Forms]![NameOfTheForm]![NameOfTheCombobox]