populate two fields with one combobox

[robboll]

MS Access 2000 form combobox

source table:
Field1-Field2
a----------alpha
b----------bravo
c----------charley


If I select "a" from a dropdown on my form to populate field "letter",
what needs to be done so that "alpha" populates a second field
"phonetic"

Thanks for any tips!

RBollinger

 

[fredg]

MS Access 2000 form combobox

source table:
Field1-Field2
a----------alpha
b----------bravo
c----------charley

If I select "a" from a dropdown on my form to populate field "letter",
what needs to be done so that "alpha" populates a second field
"phonetic"

Thanks for any tips!

RBollinger

One way is to code the combo box AfterUpdate event:
Me![TextControl] = Me![ComboName].Column(1)

Another way is to set the control source of the Text Control to:
=[ComboName].Column(1)

Column(1) is the 2nd column.

 

[robboll]

excellent -- thanks

MS Access 2000 form combobox

source table:
Field1-Field2
a----------alpha
b----------bravo
c----------charley

If I select "a" from a dropdown on my form to populate field "letter",
what needs to be done so that "alpha" populates a second field
"phonetic"

Thanks for any tips!

RBollinger

One way is to code the combo box AfterUpdate event:
Me![TextControl] = Me![ComboName].Column(1)

Another way is to set the control source of the Text Control to:
=[ComboName].Column(1)

Column(1) is the 2nd column.