How can i clear the form data

[Guest_imported]

when i press button to add the record , i write SQL statment in VBA using RunSQL function but i want to clear the values in the text boxes to insert another record >

there is a method :
text1.value=""
text2.value=""

but i need another method (more simple)

 

[Kalin]

This code will create a new record...
Just add it to a button named btnNewRecord on the Click event.

P.S. the button wizard can also create this code for you....

Private Sub btnNewRecord_Click()
On Error GoTo Err_btnNewRecord_Click

DoCmd.GoToRecord , , acNewRec

Exit_btnNewRecord_Click:
Exit Sub

Err_btnNewRecord_Click:
MsgBox Err.Description
Resume Exit_btnNewRecord_Click

End Sub

Grtz,

Kalin

 

[Skeptik]

Hello!!!
Just add this to the code you have on the command button!!

me.dataentry = true

This will clear all the fields and create a new record!!
Fare well...