Combo box not displaying data

  • Thread starter Thread starter Susanne
  • Start date Start date
S

Susanne

Over the years forms have been working great from a 97 Access db. Zoom to
today and for some reason it's not, and no matter what I have tried, I can't
get the employee names to appear in the combo box.

The user is to select a name from the list and the employee id is then
stored in the field. The field has 3 lines of information from the name to
another number and DOB. I have the data source to look up the info in the
employee table and the width set to 0" (employee id) and 2" (employee name).
The id will appear if I change these settings, as well as the column heads,
so I know the db is reading the column with the names, but there are no names
appearing. The tables are linked from a backend. Oh, when looking at the
data source in query mode, all the information is there.

I have converted the db to Access 2000-2003. So, any ideas?
 
Over the years forms have been working great from a 97 Access db. Zoom
to today and for some reason it's not, and no matter what I have tried,
I can't get the employee names to appear in the combo box.
I have converted the db to Access 2000-2003. So, any ideas?

Blank ComboBoxes is a bug introduced in Access 2003 with service pack 3.
There is a hotfix.
 
Back
Top