Combo Box Drop down

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top