close two forms

[laruajo]

I have a form that data is entered in, a button is then pressed to accept the data and take the users to another form where they receive a number. When the users either press the button on the first form to accept the data and go to the other form, or press the close button on the second form, i would like the first form to close. How can I do this??

 

[Russie]

You would add a line after your other commands..

DoCmd.Close acForm, "frmMyForm", acSaveNo

 

[thornmastr]

Define a global module. In that module, insert the following routine.

Public sub CloseForm1

Docmd.close acform, “form1Name”

End sub

Now, the last line of your on click event of your buttin which accepts your data should be:

CloseForm1()

It should also be called as a part of your on close event for the second form.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com