Default Value for Combo and List Box

T

Té

I created a combo box in desing view on a form. When I toggle out into form
view and choose one of the items from the box that value remains when I go on
to the next records. How can I set it up after each entry it defaults back
to "select one." So on record one on my combo box I select Visa, then when I
go to record 2 I want it to automatically default back to select one. Please
help!
 
L

Linq Adams via AccessMonster.com

I'm not sure what you mean by "Select One." Is this actually a value in your
listbox/combobox, or do you mean that you want nothing to be selected in the
listbox/combobox?

This will set them so nothing is selected:

Private Sub Form_Current()
YourListBox = Null
YourComboBox = Null
End Sub

This will set it to "Select One" if you actually have such a line in either
box:

Private Sub Form_Current()
YourListBox = "Select One"
YourComboBox = "Select One"
End Sub
 
Top