Need form filter based on combo box

[rehanemis]

Hi,

I would like to apply filter on form based on some criteria.(snap shot attached).

I just want to view the Department only which i choose from combo box(i will make combo box on form).

When I choose a department the form will show only that department and will show All values in Time column.

If I do it using the filter option it giving me accurate results but I want to do it using combo box.

Thanks for your guideline and help.

 

[James Deckert]

This sounds like a record lookup.
See if this helps. It goes into quite a bit of detail, so should help you if you need to modify anything.
https://www.youtube.com/watch?v=EdH1aIWaD-0

Edit: I haven't used a record lookup for doing what you want (find multiple records) as it is usually used to find a single record and go to it. I did some testing and got it to work by making a master form that opened a subform. Your current form would be the subform. The master form has the lookup combobox and is bound to a table. Then the subform has the 'link master fields' and 'link child fields' filled in based on what field i'm using in the combobox lookup. BTW: the lookup option doesn't appear in the combobox wizard, so cancel the wizard and create the VBA behind the combobox to do the lookup.
It works even though a little more work.

 

[James Deckert]

I created a new video to speed up my presentation, so deleted the old one. Here is the new one.
https://www.youtube.com/watch?v=nJXqMJC60oY