1 table 2 columns 1 form

[tstolk]

Hi all!

First of all sorry for my terrible English!

I have a very simple question (I think). I have a table with 2 columns in it, filled with city names and their id's. For example:

city - id
rotterdam - rd
amsterdam - ad
new york - ny
london - ld

I have a form with this city-table as a dropdown menu to fill in the control. What i now want is, when I select the city, a different text field named ID must be filled in with the corresponsding city-id.
So, how do I fill in 1 field when a edit the 2nd field?

Thnx in advance!!

 

[Sergeant]

The controls wizard for combobox will do this for you...turn on the wizard and put the combo on the form. At the last page of the wizard, click on "store the value in this field" (or something like that.)