If anyone has any experience with VBA you could help me out greatly.
Here's the way it goes, i have 3 forms. in each form is an if statement that jumps up to the next form in a certain hierachry. Form1 is the first form loaded, then Form2 and then Form3. So, once these forms have been opened, i need to be able to close them and continue code execution on the previous form.
'stuff that needs to be exectued after form2 is done running
'stuff that needs to be executed after form3 is done running
'stuff that form3 runs
the problem is that the Close statement is not closing the form like it's, seemingly, supposed to. if i do an End statement, all of the forms close and no further code exectution takes place. how do i get the forms to close themselves when the buttons are clicked?! i can't figure it out. thanks