troubleshooting Question

Access: Help with code: Using CreateEventProc

Avatar of ouestque
ouestqueFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution459 ViewsLast Modified:
I have attached a snippet of code. When I run it I get the following error:

"Run-Time Error '57017': Event Handler is invalid"

Will someone help me make the attached code work?


DoCmd.OpenForm "SampleForm", acDesign
 
a = 0
b=0 
Do
    
    Set cmd = CreateControl(b, acCommandButton)
        
    cmd.Name = "Custom " & a
    cmd.Caption = "Customize " & a
    cmd.OnClick = "[Event Procedure]"
    
InsertCode = Forms![SampleForm].Module.CreateEventProc("Click", cmd.Name)
 
b=b+1
a = a + 1
rst.MoveNext
count = count - 1
Loop While (count > 0)
 
DoCmd.Close acForm, "SampleForm", acSaveYes
ASKER CERTIFIED SOLUTION
stevbe

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 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 2 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