Hello Everyone, i am using VB to make a front end of my Access database.

But i cant seem to make a button so that when you click it, it erases all the fields, and then lets the user enter a new record, here is my code, it keeps saying i cant do anything while the record is closed.

Thanks for your help everyone

Private Sub AddNew_Click()
Text1.Text = ""
Text2.Text = ""
Text3.Text = ""
Text4.Text = ""
Text5.Text = ""
Text6.Text = ""
Text7.Text = ""
Text8.Text = ""
Text9.Text = ""
Text11.Text = "Comments"
Set rs = Nothing
Set rs = New adodb.Recordset
End Sub