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
Mooseman
Hard to say with the information maybe
textbox1.value=""
regards pike
If the solution helped please donate here to the RSPCA
Sites worth visiting;
J&R Solutions - royUK
AJP Excel Information - Andy Pope
Spreadsheet Toolbox
The Code Cage - Symond Lloyd
VBA for smarties - snb
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
Alan
Click the * below to say thanks.
Database Principles
Pivot Table Tips
Good Excel Video Tutorials
Sumifs or SumProduct
DataPig Access Tutorials
MS Query Tutorial
Worst Pie Chart Ever?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks