Multiple control update from one drop-down box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to offer a multiple column combo box drop-down in one control on
an ACCESS form and have it automatically insert the other column data into
several respective controls on the same form in the same user step.
 
One option would be to use an equation in the Control Source of the other
controls (textboxes).

Example:
=cboMyCombo.Column(1)

The column index number is zero based. This means that 0 is the first
column, 1 is the second, etc. Doing this will have the values in the other
columns display in the textboxes, but they won't be editable.
 
Back
Top