Lookup Not Working

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MikeM - 19 Oct 2007 14:53 GMT

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?

Reply to this Message

mscertified - 19 Oct 2007 16:34 GMT

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

-Dorian

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

Reply to this Message

MikeM - 19 Oct 2007 16:48 GMT

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

> If this is a split database, check that your links are still ok.
>
[quoted text clipped - 5 lines]
> > 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?

Reply to this Message

John Spencer - 19 Oct 2007 16:49 GMT

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.

Signature

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
[quoted text clipped - 3 lines]
> it
> on another pc and the lookups work fine. Issue with SP3?

Reply to this Message

MikeM - 19 Oct 2007 17:16 GMT

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.
>
[quoted text clipped - 18 lines]
> > it
> > on another pc and the lookups work fine. Issue with SP3?

Reply to this Message