Lookup Not Working

[Guest]

Running Access 2003 SP2. Have several tables and forms that utilize combo
boxes to "lookup" info from other tables (i.e., state abbreviations) and
everything is working fine. I installed SP3 and now all the combo boxes are
displaying blank entries. I copied the database to a flash drive and ran it
on another pc and the lookups work fine. Issue with SP3?

 

[Guest]

If this is a split database, check that your links are still ok.

-Dorian

 

[Guest]

It is not a split database. All tables and forms are in the same database.

 

[John Spencer]

Problem with SP3 that MS is aware of.

Quoting from Ken Snell

[IS] the field to which the combo box is bound ... a text field and has
a Format property setting for the field in the table? If yes, this is a bug
that has been reported by many ACCESS users during past weeks. It apparently
is a bug in Office 2003 SP3, which was released by MS about a week ago. MS
is aware of the bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view.
Otherwise, concatenating the field's value with an empty string also seems
to "overcome" the problem.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

Thanks John for the info. I made the change as you suggested and it's
working now. Thanks again.

Problem with SP3 that MS is aware of.

Quoting from Ken Snell

[IS] the field to which the combo box is bound ... a text field and has
a Format property setting for the field in the table? If yes, this is a bug
that has been reported by many ACCESS users during past weeks. It apparently
is a bug in Office 2003 SP3, which was released by MS about a week ago. MS
is aware of the bug and is working on how to fix it.

In the meantime, the "complete workaround" is to remove the Format
property's value from the field's properties in the table's design view.
Otherwise, concatenating the field's value with an empty string also seems
to "overcome" the problem.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Running Access 2003 SP2. Have several tables and forms that utilize combo
boxes to "lookup" info from other tables (i.e., state abbreviations) and
everything is working fine. I installed SP3 and now all the combo boxes
are
displaying blank entries. I copied the database to a flash drive and ran
it
on another pc and the lookups work fine. Issue with SP3?