Cancunpete
New member
- Local time
- Today, 10:35
- 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
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