troubleshooting Question

Automatically filling a check box via a macro

Avatar of DJ P
DJ PFlag for United States of America asked on
Visual Basic.NETMicrosoft OfficeDatabasesMicrosoft Access
6 Comments1 Solution95 ViewsLast Modified:
I have a simple macro (see below) for an access 2013 database that has you can see prompts for a message box to inform the user to select a check box (called "complete trans"). The problem is a good portion of our folks forget to check the box (go figure). What I would like to do is have the box automatically checked once they select ok on the message box. What is the line of code to accomplish this? Below is my macro.

Option Compare Database

'------------------------------------------------------------
' Macro1
'
'------------------------------------------------------------
Function Macro1()
On Error GoTo Macro1_Err

    DoCmd.RefreshRecord
    DoCmd.OpenQuery "Append History Database", acViewNormal, acEdit
    DoCmd.RefreshRecord
    Beep
    MsgBox "UNCHECK THE ""COMPLETE TRANSACTION"" BOX BEFORE PROCEEDING.", vbCritical, "SE-SELECT CURRENT RECORD"

Macro1_Exit:
    Exit Function

Macro1_Err:
    MsgBox Error$
    Resume Macro1_Exit

End Function
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros