Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Clearing combobox entries 1

Status
Not open for further replies.

pmkieffe

Technical User
Jun 12, 2006
32
0
0
ID
Hi,

I form with comboboxes. The user selects an entry from the combobox and with the on click event of a command button, the combination of combo box entries is saved as a row in a new table.

I would like three of the comboboxes to remain on the selected value until the user changes the value (which is how they all behave now).

But I would like the other four combo boxes to be cleared (how the combo boxes appear when the form is first opened) after the command button is clicked.

Is this possible? Is there code I can enter in the already present "on click" event?

Thanks,
pmkieffe
 
Set the value of the combos to Null:
Code:
Me!MyCombo = Null
HTH,

Ken S.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top