Clear the FORM

[Surjer]

Is there a way to clear a form completely of data when a Command button has finished .

1.) Users log in to the form
2.) Users input data into text boxes
3.) Users click a command button to validate there text
4.) User Click a command button to Submit (Insert) there data
5.) How do I do 2 thru 4 (fresh) after 4 is done?


OK, Actually

I have some variable that are Public'd as Date.
Is there a way to clear the variable?

Variable x = nothing?????

 

[Jack Cowley]

Open your form in design view and open the forms property sheet. Click on the Events tab and place the cursor in the Before Update event and then press the F1 key. You will see some example code of how to validate the fields on your form. If you use this method then you don't need any command buttons to check the controls for data or to move to then next record as it will all happen automatically.

VariableX = "" should do the trick.

hth,
Jack