empty drop down box

[Jacquie]

I have a table called tClasses. Its primary key is CID, a simple 3-letter
code.

I have a table called tSchedule. I created a field called CID and used the
lookup wizard to look up the CID from the tClasses table.

When I view the form however, the drop down box does not have any CID's
listed -- just blanks -- even though there are over 30 CID's in the tClasses
table.

Row source: SELECT tClasses.CID FROM tClasses ORDER BY [CID];
Bound Column: 1
Column Count: 1
Column Heads: No
Column Widths: 1"
List Rows: 8
List Width: 1"
Limit to list: No

I already did a compact and repair several times.

Why aren't I seeinig the CID's in the drop down box? Thanks!!

 

[Jeff Boyce]

Jacquie

Having a combobox missing its rows sounds like a problem that's been
reported as showing up after SP3 was installed on Office 2003. What version
are you using?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jacquie]

Probably. Any work arounds?

 

[John W. Vinson]

Probably. Any work arounds?

Thanks to Tony Toews for pointing this out:

"Combo box controls and list box controls display no value or
incorrect values in Access 2003 after you install Office 2003 Service
Pack 3." And a few more problems SP3 introduced.

Description of the Access 2003 post-Service Pack 3 hotfix package:
December 18, 2007 - 945674

http://support.microsoft.com/kb/945674


John W. Vinson [MVP]

 

[pcbins]

This 945674 hotfix does not work for me. Any other way to fix this?