HELP! Need to use Combo Box to filter records in Access Form

[jgelpi]

I'm trying to use a combo box to filter out records on an Access form. So the user will only see the records that have the same Organization ID as they selected in the combo box. I have tried SQL statement(s) and that has not proven successful. Any suggestions from the VB side? I've tried using the .Filter command but I don't think I am using it correctly. Any suggestions/help will be much appreciated.

 

[KenHigg]

Use the combo box value as the a parameter in the forms underlying query. And do a form requery in the combo box on change event.