Help! Glitch in my form

[shannaj via AccessMonster.com]

I was hoping someone could help me. Today I opened one of my forms that my
department uses on a daily basis and there seems to be some glitch with it.
I have a lookup from one of my tables in my form. Today when I try to type
in it, the primary key column is gone. It is a combo box so you can see the
2 columns that I have it looking up, but you can only see the items in the
2nd column, the 1st column items are gone is gone. No one could have messed
with the tables or the form itself because they do not have access to it. I
have looked over my tables and do not see what could have caused this. I
have also tried making a couple of new tables and using one to look up the
other and nothing will show also. This is weird. Any one know what could
have happened?

 

[Linq Adams via AccessMonster.com]

Ha anything changed recently? Your problem sounds suspiciously like a bug the
Access 2003 service pack, SP3 causes. IF you're running 2003, have you or has
your IT techies installed SP3? If this is pertinent, have a look at Allen
Browne's write up on this, which includes a link to a hotfix for the problem.

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

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[shannaj via AccessMonster.com]

That worked! Thank you so much!

Ha anything changed recently? Your problem sounds suspiciously like a bug the
Access 2003 service pack, SP3 causes. IF you're running 2003, have you or has
your IT techies installed SP3? If this is pertinent, have a look at Allen
Browne's write up on this, which includes a link to a hotfix for the problem.

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