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?
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

Signature
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000/2003
shannaj - 11 Feb 2008 21:51 GMT
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