How to reset form?

[softwareguy74]

Hi,

I have a form which has numerous objects on it such as text boxes, check boxes, option boxes, etc..

After the user has input all the data and made all the selections the user can then hit the "Next" button which saves the data to the database an allows the user to start a new record.

No objects are bound to the data source so simply moving to a new record will not do anything for me in the way of clearing all the data previously entered by the user.

So my question is, how can I quickly and easily clear all objects of the user entered data to their original default values? Is this possible?

any help and examples would be appreciated..

Dan

[shwan]

Public Function TextBoxClearAll(FormPrm As Object)
Dim objTextBox As Control
For Each objTextBox In FormPrm
If TypeOf objTextBox Is TextBox Then objTextBox.Text = ""
Next

'u can also apply to other controls in for...next