check save and reset

Cancunpete

New member
Local time
Today, 07:13
Joined
Sep 18, 2006
Messages
1
I have a form I have created used to inventory items on trailers.
User enters the trailer number, uses labeled checkboxes to indicate items on the trailer. I then added a save button to update the trailer database.

Now what I want it to do is clear all the checkboxes so a new number can be entered an start the process over for a new trailer.

Ive added this command to the save button.

Option Compare Database
Option Explicit

Private Sub save_datta_Click()
On Error GoTo Err_save_datta_Click


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

Exit_save_datta_Click:
Exit Sub

Err_save_datta_Click:
MsgBox Err.Description
Resume Exit_save_datta_Click

End Sub

Im trying but I am in over my head.

Thanks
 

Users who are viewing this thread

Back
Top Bottom