I'm working on creating a combobox that will be limited to the data found in a table named "departments" in an ms access db. The combobox value stored in a separate dataset and saved to a different table in the same database is limited to the list loaded from the "department" table. I have the Use databound items checked with these settings:
Display Member: DepartmentName
Value Member: DepartmentID
Selected Value: tCriteriaBindingSource - Department <<<-- This is the different dataset and should store the desired value from the combobox b ut the form locks up and I can't tab off or even close the form once something is selected from the drop down list.
I'd love to do this without using ADO. Is there a way to do this with just the settings available in the combobox itself?