Clearing Form Data

[s.carter]

I have 4 unbound items on a form (2 combo boxes and 2 text boxes). Once you do a search and all 4 boxes are populated, you can do another search but if the user is distracted and forgets to select the second dropdown they will be looking at the wrong information in text boxes 3 and 4.
I googled "clear all" and "new search" but all the explanations were rather confusing. I saw a video using the button control and the undo feature to clear a form - when I tried it it said it was unavailable.


Any ideas?

[ItsMe]

Not sure how the User is creating the issue. In other words, you will need to find the correct event handler to place your code. Otherwise, the undesirable results will persist. Aside from that, you can clear the value of a combo using

Me.ComboName.Value = ""

[s.carter]

Can you tell me more? I've tried that code on On Click, On Change and Before Update and it gives me errors.

[ItsMe]

Here is an example. The reset is in the Code-Behind the button click event.

[s.carter]

Thank you. This is perfect!

[ItsMe]

OK, post up if you get stuck again.