unbound combo box with invisible entries?

[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-

 

[Douglas J. Steele]

Sounds as though you're using Access 2003, and you recently applied SP3.

Check out the hotfix at http://support.microsoft.com/kb/945674

 

[fredg]

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-

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

 

[mary r]

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-