BabyMB
Computer
- Feb 7, 2003
- 1
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!
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!
