Default Value for Combo and List Box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Té - 09 May 2008 00:31 GMT

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!

Reply to this Message

Linq Adams - 09 May 2008 03:17 GMT

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

Signature

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

Answers/posts based on Access 2000/2003

Reply to this Message