Multiple control update from one drop-down box

[GerryFinch]

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.

 

[Wayne Morgan]

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.