View Full Version : When I go to my next record combo box value stays in the box


S_DeLaire_2002
03-01-2002, 04:33 AM
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
03-01-2002, 04:35 AM
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
03-01-2002, 04:38 AM
How do I do that?

Lisa S
03-01-2002, 08:28 AM
You need to add the following code to the Form's On Current Event.

Private Sub Form_Current()
yourcomboboxname = fieldname
End Sub