Drop down list not showing on one machine

C

CD Tom

I have a problem with a drop down list. The database is located on a server
and each machine has the program loaded locally. All machines but one work
fine when the user selects a simple drop down list, the one machine only
shows a blank list when the user selects the list. I've looked at the
references and everything seems fine there. I've tried reloading the program
but still will not show anything in the list, I've tried changing the font
thinking that maybe it was to large or small, tried opening the list box but
nothing. All other users don't have this problem, does anybody have any
suggestions as what to try now.
Thanks for any help this is driving me crazy.
 
K

Klatuu

Put the offending computer in the middle of Bay 6.
Get your 45-70 and......

Howdy, Tom. Can you open the query or table that is the row source of the
combo directly?
 
C

CD Tom

I like your first thought and that has been in the back of my mind.
When I have the program open in development mode I can look at the table and
see the data but when I bring up the form that drop down list doesn't show
anything. I don't get any messages if just shows up blank.
 
C

CD Tom

the answer it your question is yes. The thing is this is just a simple list
with only a code A B C etc in it, I can have the user type the letter in and
it will take.
 
K

Klatuu

Are you using a query, or just the table?
Does this computer have issues with any other objects?
Was this just a working copy that you installed on the computer?
This is a very strange problem, but since you said you already checked the
references, I don't really know.
Have you tried a decompile and a compact and repair?
Last ditch would be to delete the control, and recreate it.
Let me know how it works out.
 
C

CD Tom

It is a query.
This isn't the only problem but the other problem is happening on other
computers also (but not all). I've reloaded the program from the server but
get the same problem. I've also reloaded the program from one of the
computers that is working fine, but still get the problem.
I have decompiled or compact and repair but I'll try that.

If I find the answer I'll let you know.
My other problem is kind of the same issue except it has to do with a menu
that the program uses. The top menu bar is setup with different options the
user can use and depending on the users login and password some of the
options are set to false so the user doesn't have the option of selecting
that option. All other menu options show up fine except for this one that
again is blank, although I do get an error message ( I don't have it here but
will get it and pass it along). Again this only happens on one of two
machines and the funny thing is that I can get it to work and it will work
for a couple of days and then it stops working again. Now you know why I
don't have any hair left.
I'll post another question when I get the error message captured.
 
Top