K
Kevin Sprinkel
In *most* instances, it is undesirable to store this data
redundantly, since you can display it on a form using the
Column property of the combo box, or by using a query
joining the two tables.
This strategy is recommended when the "lookup" table data
is static. If, however, the text associated with a given
Ref will change over time, you'd want to capture its value
at the time the record was entered or edited.
The easiest way is to do so is to include the Text as a
column in the Row Source of the combo box, and use the
AfterUpdate event to place the corresponding value into a
disabled control bound to the A1 field. Assuming the text
is the second column (index=1), the code is:
Me![A1] = Me!YourComboBoxName.Column(1)
HTH
Kevin Sprinkel
redundantly, since you can display it on a form using the
Column property of the combo box, or by using a query
joining the two tables.
This strategy is recommended when the "lookup" table data
is static. If, however, the text associated with a given
Ref will change over time, you'd want to capture its value
at the time the record was entered or edited.
The easiest way is to do so is to include the Text as a
column in the Row Source of the combo box, and use the
AfterUpdate event to place the corresponding value into a
disabled control bound to the A1 field. Assuming the text
is the second column (index=1), the code is:
Me![A1] = Me!YourComboBoxName.Column(1)
HTH
Kevin Sprinkel