Clearing Drop Down Boxes

[Guest]

I have numerous drop down boxes in a "Student Input Form" that get their
values from the table 'Students'. When I move to the next record, the drop
down boxes that I have selected and therfore have inserted in the table
'Students' are correct. Those drop boxes that I did not used and would not
have placed any value in the Students table, show the last value from the
previous record, even though it is not sorted and this is confusing to the
data input volunteer. I need the boxes to clear or resort to a clear record.
Can you help me?

 

[Allen Browne]

Use the Current event of the form to set the unbound combos to Null:

Private Sub Form_Current()
Me.[Combo1] = Null
'etc.
End Sub