Access 2013: Sub Form Navigation Button VBA Codes are Replacing Eachother
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.
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.
in your db, do a compact and repair