I am trying to do a simple lookup wizard using two tables. I am entering only text with no characters, numbers, or spaces as a text value (properties) in table 2 (from which to pull the lookup values). In table 1, I select "lookup wizard" & select the correct field in table 2 as my lookup range. Once I do this, it automatically changes the data type field to number and the field size to long integer. It will alllow me to select items from the lookup list, but when I try to do a query on this field in Table 1, I get a "data type mismatch error." I have tried this on 2 different computers, and on a third one using 2007. The same problems happened consistently in all attempts.

HELP!!!!!!

The problem is DO NOT USE LOOKUPS AT TABLE LEVEL....

See here for more about that:
http://www.mvps.org/access/lookupfields.htm

Use lookups at FORM level, not table level.

As Bob has already stated, Lookup Fields in tables are discouraged. Putting a ComboBox on a form that does the same thing is however just fine and strongly recommended.

Thank you, Bob. Can you tell me why it does this?

Freitag

Thank you, Bob. Can you tell me why it does this?

Freitag
It explains it in that article I gave the link to.

Thank you!