Combo box not displaying data

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

Rick Brandt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top