REFERENCE PROBLEM? Combo Box is not working on one PC.

[Rob G]

(MSACCESS 2003 - Windows XP Pro.)

I have a client PC that does not show all the columns from a query in a
Combo Box. All other PC's show the form as it was designed. The Access
clients are run from a link to a shared file server and are therefore running
the same client.

I think its a reference problem and I'm testing the suggestions listed on
the helpful link:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html tomorrow or
Tuesday.

Has anyone also seen this before?

As a Test, I created a new database and a new workform with only one combo
box linked to one split backend table. The form runs on one PC but not the
other. Both are Windows XP Pro, MSACCESS 2003, and windows updates and
microsoft updates have been run on all client systems and the server.

If you agree its a reference problem let me know - or - let me know if there
is another suggestion to follow. I searched the forum and I know I've seen
this, but I couldn't find this problem as its related to Combo Boxes.

Thanks for all your help.

Rob.

 

[Ken Snell [MVP]]

Does the combobox control (or the field to which it's bound) have a value in
the Format property? If yes, you've been bitten by a new bug introduced by
Office 2003 SP3 package. You'll need to apply a hotfix:

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

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

 

[Rob G]

I tested this patch today and it did indeed fix the problem with the Combo
Box.

Thank you so much for sending me in the right direction.

Rob.