Using dropdown box to insert values in another control??

[Stephen]

I have a dropdown box on my form with ten cities listed.
When the user selects the city, I want the corresponding
zipcode (that I would also list somewhere) to appear in
another control on the form, as well as to be inserted in
the "zipcode" field of the underlying table..Could
someone point me in the right direction so I can do this.

Thanks
Steve

 

[Ken Snell]

Use the code at this URLfor what you seek to do:

http://www.mvps.org/access/forms/frm0058.htm

 

[Stephen]

Got it, thanks..I used a vb script to update the value of
a non-visible text box on my form to contain the value of
the combo box control, and because the non-visible text
box was bound to a field in my main table, that value was
placed into the table.

Steve