Command Button To Save & Clear

**Mooseman60** · 04-30-2011, 04:21 AM

I have created a form with a subform in it. I have craeted a command button to save the data which works find but I also need it to clear the text boxes as well.

Private Sub Command24_Click()
On Error GoTo Err_Command24_Click


    DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_Command24_Click:
    Exit Sub

Err_Command24_Click:
    MsgBox Err.Description
    Resume Exit_Command24_Click
    
End Sub

**pike** · 04-30-2011, 05:49 AM

Mooseman

Hard to say with the information maybe

textbox1.value=""

**alansidman** · 04-30-2011, 07:38 AM

Is your form and subform bound to table(s). If they are, then you do not need to save as this happens automatically in Access. If you want to open a new record, then add a command button and use the wizard to open a new record which will have nothing in the input text boxes.

Alan