View Single Post
  #4  
Old June 22nd, 2004, 01:33 PM
external usenet poster
 
Posts: n/a
Default Understanding a combo box filling another table's field

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

.