VBA to Close forms

[satty]

Hey people!

i have many forms within my access database. instead of using the buttons and macros to navigate, i have used images. however, i was wondering:

- if i could use VBA to just that just closes the form. i dont want to have to create a macro for each button to close different forms.

Something like Form.Quit or something. is this possible? basically one VBA code that will close any form when the button is clicked.

Thanx Guys

 

[bat17]

The VBA command to close the active window is
DoCmd.Close
Put this on the ON Click Event for the button in the code module behind the form.

HTH

Peter

 

[Dugantrain]

You will need to do this in a Standard Module and pass the form argument from your form-level modules:

In the Standard Module:

Public Function Close_Form(strForm as Form)
DoCmd.Close AcForm, strForm
End Function

In the Module of every form that you'd like to close

Your_Button_On_Click()
Call Close_Form(Me)
End Sub