I have an unbound combo box with the Row source based on a query, and the result of the Combo Box is incorporated into an SQL staement. I can select any of the numbers from the drop down list ok, but when I type in a number that is in the list, I get the message "Not in List", but if I type in a 2-digit number it is ok (i.e. 17 is ok, but 7 is not, yet both are in the list). Any Ideas ??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Strange ComboBox behavior
- Thread starter lizray
- Start date
Hi lizray,
I have found quite a few threads around which discuss similar problems to what you describe.
See if this page offers any help...
Regards,
Peter.
Remember- It's nice to be important,
but it's important to be nice
I have found quite a few threads around which discuss similar problems to what you describe.
See if this page offers any help...
Regards,
Peter.
Remember- It's nice to be important,
but it's important to be nice
- Status