I'm sorry. I used the wrong terminology. The ZipID is a combobox, not a
lookup. When I look at it in the table, I see all 4 columns and everything
looks correct. However, when I switch to the form, it does not give me the
combobox (right word?) to choose from. I have another field that I had setup
originally as a combobox that shows correctly on the form and the drop down
list is there to choose from. I designed the form before I switched the Zip
to a combobox and I cannot figure out how to correct it without having to
start the form over from scratch.
--
Thanks for any help you can give!

Elizabeth


"Jeff Boyce" wrote:

Elizabeth

It sounds like you've discovered (re-discovered) one of the many reasons
folks here in the newsgroup recommend against using the Lookup data type in
table definitions.

Access tables store data, Access forms (and reports) display data. Don't
fall into the trap of trying to use Access tables as if they were
spreadsheets -- they aren't.

The way you'll find most folks here handle "lookup" is to store the foreign
key value in your main table, then use a combobox in a form to "look up"
values. That way, you can see "all four columns" when you make your choice.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Elizabeth" wrote in message
...
I have a table with zip code, state, city, and county. The ZipID is used
as
a lookup in another table. How do I get all four columns to show on the
form? I am increddibly new at this and teaching myself as I go. Please
be
specific.
--
Thanks for any help you can give!

Elizabeth