troubleshooting Question

Access 2013: Sub Form Navigation Button VBA Codes are Replacing Eachother

Avatar of mdstalla
mdstalla asked on
Microsoft OfficeMicrosoft AccessMicrosoft Applications
10 Comments1 Solution2405 ViewsLast Modified:
I have several (sub) forms that open from 2 Control Buttons at the bottom of each page (“Back” and “Next”).  I have embedded code into each button so that Access will display the appropriate (sub) forms if/when they are clicked.  The problem I’m facing is that the code I am writing into each button is replacing the code for other buttons.

For example:

When I type in the Code for the Next Button on Form 3, the Code for the Back Button on Form 1 is replaced.

Sub Form1 (Option Group—‘Offsite’ + Control Button—‘Next’) brings up Sub Form 3.  That is correct!

Sub Form3 (Control Button—‘Back’) brings up Sub Form 1.  That is correct!

Sub Form3 (Option Group—‘Yes’ + Control Button—‘Next’) does not work.  So I re-type the code into Sub Form3’s Control Button—‘Next.’

PROBLEM:  That code I just typed into Sub Form3’s Control Button—‘Next,’ is now appearing in Sub Form3’s Control Button—‘Back.’

Can any help me cure this problem?  I have attached the database; the “Navigation Form1” is the Parent Form with the Sub Forms.

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