Not in List Problem with Numeric Values

  • Thread starter Thread starter BMR
  • Start date Start date
B

BMR

Hello,
I have a combo box that looks up numeric values from
another table, my problem is when I enter the numeric
value in the field I get the Item Not in List error even
though the number is in the list and it forces me to have
to choose from the drop down list. Anyone have ideas on
why this is so?
 
I tried it and it appears to work. What data type is the field that contains the numbers
for the Row Source? What data type is the Control Source? If the combo box has multiple
columns, is the number you are typing the item that's in the first visible column?
 
Its strange, it works just fine on my other machine.
Friday it wouldn't work on my laptop running Access 2000
on Win XP, Monday it works fine on my desktop running
Access 2002 on Win XP. The data type is integer for the
row source and the number I am typing is the first
visible column of my combobox. Strange. Anyhow, let me
know if you have any additional info that may help.

Thanks,
Mike
-----Original Message-----
I tried it and it appears to work. What data type is the
Click to expand...
field that contains the numbers
for the Row Source? What data type is the Control
Click to expand...
Source? If the combo box has multiple
 
When it works on one machine but not another, the usual things to check are Office Service
Pack level, Jet Service Pack Level, MDAC Service Pack level, and Operating System Service
Pack level. Also, check the References to make sure that they are the same on both
machines and that none are listed as Missing. To check references, open an Access code
window (Alt+F11) and go to Tools|References.

http://widowsupdate.microsoft.com
http://office.microsoft.com/officeupdate/default.aspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;239114&Product=acc2000
http://www.microsoft.com/downloads/...e3-c795-4b7d-b037-185d0506396c&DisplayLang=en
 
Back
Top