Getting a CBO to still show both columns after choice is made

[Howlsta]

Hi peops,

I know how to let the user see multiple columns in a dropdown by setting columns widths likes so:

5cm;4cm etc... and also changing column count

but after the user makes a selection how do I get both columns to still show in the combo box


thanks

 

[Rich]

You can't, either join the two fields as one ie. [Field1]&[Field2] or use an unbound textbox to display the other value

 

[Howlsta]

Thanks for the suggestions, the concatenation would do the job I didn't think of that.
I was trying to use an unbound textbox for the other and have done it successfully in another form, but as this is a subform the unbound textbox will display the same value for every record i.e.

Make Model
Vauxhall Astra
Vauxhall Escort
Vauxhall Colt

only correct for first tuple, but if I move to the next record

Ford Astra
Ford Escort
Ford Colt

if there is no solution for this then I will settle for the concatenation, I just means the combo box will have about 6 times more choices, so slightly less elegant!

i'm using this code in the sub forms current event

Private Sub Form_Current()
If Me.FORM_NUMBER <> "" Then
Me.cboMake = DLookup("[VehicleMake]", "tblVehicle", "[VehicleID] = " _
& Forms!pbmainvehicleinfo1!VehicleID)
Me.cboMake.Requery
Me.cboModel.Requery
End If

End Sub

i