populate two fields with one combobox

  • Thread starter Thread starter robboll
  • Start date Start date
R

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
 
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
Click to expand...

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.
 
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
Click to expand...

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.
Click to expand...
 
Back
Top