Drop box problem

[JWood]

I have a DB that we have been running for years. It has several customers and
they are listed by their system serial number. When I open a ticket for them
I select the system serial no. from a drop down list, which then pulls up all
their info and such. The problem is when I select this drop list od SNs they
do not show up in the box. They are there because I can select an open area
and it will populate the info, but it is hard to choose the right one without
seeing it. As I said, the list is there, just can't see it.

It is something that has just happened recently to cause this problem. I
have tried to run recover on the file, but it made no difference. I also took
it to another machine and it is also this way.

Thanks for ANY help,

 

[Maurice]

Are you using Access 2003 and did you by any chance install SP3 because there
are some flaws in the SP. Allen browne has described them on his site and has
a link to a hotfix for what I think is the combobox problem you encounter.

http://allenbrowne.com/bug-Access2003SP3.html

hth

 

[JWood]

Maurice, Thanks. I followed the steps and the info in the drop down box was
there.
Thanks again.