Drop down list not displaying

[Rosy]

I have a database shared across a network. On all terminals except
one, the database performs perfectly. The one oddball machine won't
display drop down lists. The list opens but is empty. I am unable to
"filter" by any field that has a drop down. I first verified that
this machine was linking to the actual database. I then opened the
database from it's origin with the same issue occurring. I have
deleted and recreated the drop down, rebooted, run microsoft updates,
uninstalled and reinstalled office suite. I don't know what else to
try. Has anyone else ever had this problem?

[Salad]

Rosy wrote:

I have a database shared across a network. On all terminals except
one, the database performs perfectly. The one oddball machine won't
display drop down lists. The list opens but is empty. I am unable to
"filter" by any field that has a drop down. I first verified that
this machine was linking to the actual database. I then opened the
database from it's origin with the same issue occurring. I have
deleted and recreated the drop down, rebooted, run microsoft updates,
uninstalled and reinstalled office suite. I don't know what else to
try. Has anyone else ever had this problem?

I haven't. Does the user use a copy of Access? If so, why not open the
front end...or create a new database. Then go to Forms/New/Design and
create a dropdown, save and run. You should be able to get the
ListCount value...in the GotFocus event enter something like
msgbox Me.ComboboxName.ListCount
The listcount may have 1 added to it if you have column headings on.

It's quite possible something is goofy. You could enter stuff like
msgbox Me.ComboboxName.RowSource
to see what the current rowsource is.

It's possible there really aren't any rows and columns to display.

[Ken Snell]

By chance, did that PC get upgraded to SP3 for Office 2003? There is a bug
that sounds similar to what you're seeing....

--

Ken Snell
<MS ACCESS MVP>
"Rosy" <kr****@portlite.comwrote in message
news:11*********************@r29g2000hsg.googlegro ups.com...

>I have a database shared across a network. On all terminals except
one, the database performs perfectly. The one oddball machine won't
display drop down lists. The list opens but is empty. I am unable to
"filter" by any field that has a drop down. I first verified that
this machine was linking to the actual database. I then opened the
database from it's origin with the same issue occurring. I have
deleted and recreated the drop down, rebooted, run microsoft updates,
uninstalled and reinstalled office suite. I don't know what else to
try. Has anyone else ever had this problem?