PDA

View Full Version : Solved: Comobobox not working properly



bosboer
04-24-2005, 02:42 AM
A combobox on my form is not working properly. It works fine when you select an item from the dropdown list. But then you enter a value (by keyboard) that is in the dropdown I get each time the NotInList event. Then the NotInList event will generate an error because the item is allready in the list.

Any idea's about what's going wrong?

OBP
04-24-2005, 10:56 AM
The most likely reason for this error is that you are entering what you want to see rather than the Bound Column. This happens if you have 2 columns where say one is the key field, and ID or similar (which Access hides for you) and the other is a name etc that you want to choose. If you type the name in you get an error because Access expects the ID.

bosboer
04-24-2005, 02:05 PM
I found the error. It seemed releated to a missing library of an ActiveX usercontrol. Removing the reference to the missing library solved the problem.