When I go to my next record combo box value stays in the box

[S_DeLaire_2002]

When I go to my next record combo box value stays in the box. How do I make it so that when I go to the next record it resets?

 

[Pat Hartman]

Since the combobox is unbound, you need to fill it when the current record changes. Access only automaticaly takes care of bound controls. Put the code into the form's Current event.

 

[S_DeLaire_2002]

How do I do that?

 

[Lisa S]

You need to add the following code to the Form's On Current Event.

Private Sub Form_Current()
yourcomboboxname = fieldname
End Sub