Filter forms data based on value of password form combo box selection

[BabyMB]

I need to take the value of a combo box and pass it the form that will open. I want only the data that matches the passed value of the combo box. Ex:

I have a password form for users. If Michelle is selected and her SupevisorID for the bound field in the combo box is 5 then when the form is open only the data with a 5 in the SupervisorID field for the view that is the forms data source will be available to be viewed.

When I attempt to do the [forms].[frmpassword].[txtSupID] in the views criteria it doesn't work.

When I attmpe to do the [forms].[frmpassword].[txtSupID] in a sql statement it has an error trying to convert the [forms].[frmpassword].[txtSupID] value to an integer.

Help!