ComboBox?

[Guest]

I have a comboBox with 4 fields; fldDeviceNo(unique ID stored in underlying
table), fldManufacture, fldModel, fldModel#.

When a device is selected, I need all the fields to be displayed in the
forms field.
Is this possible, or do I need to concatenate these fields?

Thanks Rob

 

[Guest]

All in one field or each in its own field?
If all in one field:
Me.SomeControl = Me.MyCombo.Column(0) & " " & Me.MyCombo.Column(1) & " "
Me.MyCombo.Column(2) & " " Me.MyCombo.Column(3)

If each column in its own control:

Me.SomeControl = Me.MyCombo.Column(0)
Me.AnotherContro = Me.MyCombo.Column(1)
etc

In either case, use the AfterUpdate event of the combo.