I would like to populate a (another) table field based on user combo box selections.
I would like a combo box with selections A, B, C, D, E, etc.
If combo box A is selected, it would populate with the numeral 1; if B were selected, it would populate with the numeral 2; if C were selected, it would populate with the numeral 3; etc.
So, we would have a combo box in the form, but it would not populate a table field with the combo box selections, but with values driven by the combo box selections.
Is this possible?
Ron