Issue w/ VBA code for Opening/Closing Forms

[need_help12]

Good morning. First time writing any type of VBA code in Access, and seeking some assistance. On the switchboard I've created in my dummy db, I have 5 buttons that all function correctly in prompting new forms. As the end user clicks on any selection, I'd like the switchboard form to close once the new form opens. I was successful in making this happen for the first button "New Vendor Record", however as I attempted to duplicate this for the remaining buttons, I was only able to get the new forms to open, and not close the switchboard.



I simply copied the code from the command button which does function, and applied the applicable command button and forms to it as needed, but to no avail. I'm assuming its not this simple.

Would appreciate anyone with the VBA knowledge to chime in. I've attached my dummy db below.

[RuralGuy]

You do know that only the "New Vendor Record" button is the only button with [Event Procedure] code, right? The other 4 buttons are [Embedded Macro] buttons.

[need_help12]

I do now......

[RuralGuy]

I'll bet you will solve it now.

[need_help12]

Rather quickly too, thanks for pointing out my oversight! Much appreciated for the help.

[RuralGuy]

Anytime! I marked this thread as Solved for you using the Thread Tools at the top of the thread.