unbound combo box with invisible entries?

  • Thread starter Thread starter mary r
  • Start date Start date
M

mary r

I'm working with an unbound combo box to move to a selected record in a form.
I've done this plenty of times before but have never encountered this
problem: though the record source exists, it does not display.

The combo box shows up blank with a blank dropdown and the correct number of
blank lines for the conditions. Scrolling down through the blank lines and
clicking on one of them does move to the selected record on the form, but the
combo box value does not display till clicked. The dropdown remains blank.

Furthermore, the combo box does not recognize typed input from the user.
I've verified that it's visible, enabled, limit to list, etc. ?????

I've tried programming it from scratch, copying and changing appropriate
field names from existing code, and using the built-in wizard. Same thing
happens every time.

I really hope somebody can help on this one because I'm about to flip my lid!

Thanks in advance-
 
I'm working with an unbound combo box to move to a selected record in a form.
I've done this plenty of times before but have never encountered this
problem: though the record source exists, it does not display.

The combo box shows up blank with a blank dropdown and the correct number of
blank lines for the conditions. Scrolling down through the blank lines and
clicking on one of them does move to the selected record on the form, but the
combo box value does not display till clicked. The dropdown remains blank.

Furthermore, the combo box does not recognize typed input from the user.
I've verified that it's visible, enabled, limit to list, etc. ?????

I've tried programming it from scratch, copying and changing appropriate
field names from existing code, and using the built-in wizard. Same thing
happens every time.

I really hope somebody can help on this one because I'm about to flip my lid!

Thanks in advance-
Click to expand...

Have you recently installed Access 2003 Service Pack 3?
Could be the Service Pack 3 bug.
See this link for details on the hotfix.

http://support.microsoft.com/kb/945674
 
Checking out the hotfix now - thanks a million! I'll need to verify that the
end users' systems have the hotfix, too, though the IT guy is generally on
top of things.

I've got Windows Update set to automatic, so it's surprising that this
hasn't come through. Thanks again-
 
Back
Top