Combo Box Drop down

[Guest]

Thanks In advance.

I have a combo box that looks up Vehicles.

Each vehicle has a code against it.

When I double click the combo box I want it to look up say Mazda. (=
Vehicle_Name]

At present I Have as follows, but it does not work:-


Private Sub New_MakeCombo_DblClick(Cancel As Integer)


New_MakeCombo.Value = Forms![Cars]![Child23].Form![Vehicle_Name]

New_MakeCombo.Dropdown

End Sub

 

[Barry Gilbert]

Does the bound column of New_MakeCombo contain the same values as the
value contained in the subform's field? If you have multiple columns in
the combobox, setting the Value property will attempt to find it in the
column indicated by the Bound Column property.

Barry