combobox prefered first selection

[matrixindicator]

Is there an easy way with vba to say next ...
I have a subform menu where every next new record has besides textboxes a combobox. Every next record combobox menu should show first the previous selection.

Eg. In the first record dropdown the user select "Bread".
The second record dropdownbox should first show "Bread".
If the user select another option like "Wine" the next record dropdownbox should show "Wine" as first selection. And so on ...

 

[PHV]

Change the DefaultValue property of the combobox in its AfterUpdate event procedure.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

And you'd do that simply by

Private Sub ComboBoxName_AfterUpdate()
  Me.ComboBoxName.DefaultValue = """" & Me.ComboBoxName.Value & """"
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!