Apply Filter to a Table using Combo Box

[krizzyd]

Hello everyone, first post here!



I'm currently designing a form that will serve as a Shift Schedule as a course project. I'm trying to put a Combo Box that will filter the table (in the form) when a value is inserted (AfterUpdate). I'm wondering if you guys know the appropriate code (in either VBA or Macro) to execute this. I've tried Googling this issue but the codes I found do not work unfortunately.

Attached is a picture of my form. This form is a sub form for my Navigation Form. The Navigation Form will serve as the interface for the database.

Also wanted to add that the VolunteerID fields for both the form and the table are actually auto numbered, but masked it using an expression ->[FirstName] &","&" "&[LastName], if there is a way to filter the table using the expression I've put together, I would greatly appreciate it.

EDIT: If you enlarge the VolunteerID Combobox, you will see the names of the people under VolunteerID.

Please help me

[ranman256]

In the AFTERUPDATE,

sub cboBox_afterupdate()
If isNull(cboBox) then
   Me.filterOn= false.
else
    Me.filter = "[id]=" & me.Id
    Me.filterOn= true.
end if
end sub