Part number combo box is blank, all others work

B

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!
 
L

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?
 
B

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!
Click to expand...

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
 
Top