Part number combo box is blank, all others work

[Barry]

I've tried repeatedly to make a part number combo box work. All other combo
boxes on my form work, but for some reason this one will not. I have tryed
to use this field in other forms (by itself) to try to figure it out, it
doesn't work on the others either. Could there be something in the table or
part number field?

Please help
dumb-founded LOL!

 

[Linq Adams via AccessMonster.com]

We need to see your code assigning the cbo value and know whether your Part
Number is an actual Numeric datatype of Text datatype. Also, what
version/service pack of Access are you running?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Bob Quintal]

I've tried repeatedly to make a part number combo box work. All
other combo boxes on my form work, but for some reason this one
will not. I have tryed to use this field in other forms (by
itself) to try to figure it out, it doesn't work on the others
either. Could there be something in the table or part number
field?

Please help
dumb-founded LOL!

The Office service pack released in mid-September messes combo box
displays if there is a format set on a field in the table.

This may be your problem,

A "fix" is to concatenate the part number with the empty string ""
in the combo box's row source