I'm confused. You posted in a tablesdbdesign newsgroup. You mentioned
creating a combo box in a table. You mentioned using the wizard. These
suggest that you've selected the "lookup" data type for this field, and told
Access to use a combo box based on your ZIPCode table.

What form? You hadn't mentioned a form before.

Jeff Boyce
Access MVP

wrote in message
...
BTW, Jeff, I didn't use a Lookup data type. The form is
Contact Information (using the Contact Information table)
and the combo box on the form uses the ZIP Codes table.
G.

-----Original Message-----
Are you saying you used a "lookup" data type in your
table? This may cause
you headaches later on, especially if your ZIPCode table
uses a primary key,
and your Contact table is storing the key, but
displaying the ZIPCode.

Rather than working directly in the table, consider
using a form to display
information. Build a combo box on the form that uses
the ZIPCode table as a
row source, and is bound to the Contact table ZIPCode
field. You would need
to change the "lookup" datatype to an appropriate
different type.

--
Good luck

Jeff Boyce
Access MVP

.