Lookup isn't working properly for table fields?

[shez]

I have no idea if i did anything but I have about 5 fields in a table which are doing a look up from 5 different tables. They were all working before but now only one of them is working!

In the other ones not working, when i try to use combo box, it appears empty however if i hover over the "empty space" it seems that i am selecting something but it is hidden?

I am including a screenshot to show you how it looks (i am well aware of the < 10 post rule)

http://img27.imageshack.us/img27/9298/screenshotbg0.jpg

Solved it!

Solution:
The field in the lookup table had a > in its Format property! I don't know why that would make the fields invisible in the other table because > just means to make everything Capitals :s

 

[ChrisO]

It might mean more than that.

One possible cause is that SP3 has been installed without also adding its hot fix.

If that is the case then you may very well get other problems.

Regards,
Chris.

 

[RuralGuy]

As for LookUp fields in tables, here's a link to read:
http://www.mvps.org/access/lookupfields.htm

 

[shez]

Thanks very much for the link, but then what is the possible solution if lookup tables are "evil"? I would rather the user use a lookup table so that all the info is consistent or (it just occured to me)

that i could formally make a relationship between lookup table & the actual table like so:

personal(id, fn, ethnicityId,....)
lookuptable(ethnicityId, name,...)

 

[Dennisk]

Users can use combo boxes BUT place them on a form.

Maxim. Tables are for storing raw data.
Forms are for entering data.

 

[shez]

Users can use combo boxes BUT place them on a form.

Maxim. Tables are for storing raw data.
Forms are for entering data.

thanks for that. I CAN use combo box like this but I would also like the functionality whereby if a user enters something not in combo box, they can save it and i dont know if you can update a combo box & add it via VBA? so I decided to use lookups!


PS> if you are thinking why would I want users to be able to enter something not in the combo box then the answer is that the db will be used by administrators and although i have listed common things in combo box there may well be other things that i have not thought of eg in Ethnicity I have covered almost common ethnicity but user can specify another ethnicity.

 

[RuralGuy]

That is what the Not In List event is used for.