ComboBox?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobUCSD - 09 Feb 2007 18:23 GMT

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

Reply to this Message

Klatuu - 09 Feb 2007 18:41 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> I have a comboBox with 4 fields; fldDeviceNo(unique ID stored in underlying
> table), fldManufacture, fldModel, fldModel#.
[quoted text clipped - 4 lines]
>
> Thanks Rob

Reply to this Message