Command button code to clear form

[windwardmi]

I would like to have a command buttom on my form and on click clear all entries. Please help with the code?

[RuralGuy]

Is your form bound to a Recordset and are all of the controls bound as well?

[windwardmi]

It is bound to a table/guery as well as controls bound to the same.

[RuralGuy]

Are you just tryine to get to a *new* blank record or are you trying to wipe out and existing record? You do understand the if you are on an existing record and clear a bound control, that is also trying to clear the field in the recordset as well right?

[RuralGuy]

Did I lose you there?

[windwardmi]

No I'm not lost but in and out today. Sorry for the delay geting back.

I looking to have the command button just clear the info I just typed in and did not save and still have the form stay open.

[RuralGuy]

Me.UnDo will return all controls on the form back to what is saved in the Recordset.

[windwardmi]

Thank You.

I am now working with a MS template and the code I found is as follows:

Private Sub cmdCancel_Click()
' User wants to bail
' If an edit in progress..
If (Me.Dirty = True) Then
' Clear it
Me.Undo
End If
' And close me
DoCmd.Close acForm, Me.Name
End Sub

I think I have a simple question:
How can I stop the form from closing but still clear data I just inputed so I can enter new data?

[RuralGuy]

You lost me on that one. How about just don't Close the form? That's too easy right?

[windwardmi]

I agree. I don't want to close the form.


The code I have from the template closes the form. I am not familiar with code and was asking how to modify this code or write new code to clear the opened form and not close it so I can start new data input with cleared form.

[RuralGuy]

Just comment out the second to last line:
DoCmd.Close acForm, Me.Name
...just add a ' at the beginning of the line like:
' DoCmd.Close acForm, Me.Name

[windwardmi]

Simple, thanks for the info change. I thought I did that a couple of days ago. I guess I deleted something wrong.

When I got the code to work I noticed it truely does UnDo the data inputted but data in a past saved record will not be cleared. Is there another command to clear the data and update that record? Or is this not recommended?

[RuralGuy]

That is usually done by deleting the record and starting with a new one.

[RuralGuy]

Are you ready to call this thread Solved? It is one of the Thread Tools.

[windwardmi]

We are done and I thank you for your help.