Drop-Down Not Working For 1 User

[Archidrb]

I have an Access DB with a master and replica set up. It has been working
great for a long time (close to 5 years) even with constant changes and
upgrade.

In a form I have a combo box tied to a query pulling from a table. This way
I am able to provide options that only apply to the specific work entered
into the form. The query pulls and sorts. This field works great in the
master (for me). One user, however, can click on the combo box and a blank
box opens, if she clicks in the blank area, something will be selected. If
she types a value that is on the list, she get's an error that it is not on
the list.

I replaced the combo box, double checked the query, and it does work in the
master, but in her replica is doesn't work. Anyone got any ideas?

Thanks!

 

[Douglas J. Steele]

What version of Access? Is it Access 2003, and the user in question is the
only one who's installed the relatively-recent SP3? See whether the hotfix
in http://support.microsoft.com/kb/945674 helps.

 

[Archidrb]

Yes/Yes/No, Access 2003 - Windows XP - SP2. All of our service packs are
installed by a "log on" process set up by the network team, as are those
great hotfixes.

 

[Douglas J. Steele]

The SP3 to which I referred was for Office 2003, not for Windows XP.

Let your network team know about the hot fix. It's necessary!

 

[Archidrb]

Doug,

Got it, the fix took care of it. (It took me a couple of readings through
your explanation to understand Office SP3 and not Windows SP3, but we're
good.) Thanks!