opening and closing a popup form

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

hi all,

i have had a look for the answer to this, and I have tried several
things but i think i am still doing something wrong.

I would like to achieve the same affect as when you go to
tools/options, where a form opens, gives you options, and you can
either press ok or cancel.

i can get the form to open when you click on a button on a separate
form, but i cant get the options form to close.

could someone help me out with this?

thanks

Patrick
 
Your popup form has a Cancel button that you want to close the form?

Try this as the event procedure for your command button:
Private Sub cmdClose_Click()
DoCmd.Close acForm, Me.Name
End Sub
 
Patrick said:
hi all,

i have had a look for the answer to this, and I have tried several
things but i think i am still doing something wrong.

I would like to achieve the same affect as when you go to
tools/options, where a form opens, gives you options, and you can
either press ok or cancel.

i can get the form to open when you click on a button on a separate
form, but i cant get the options form to close.
Click to expand...
I don't understand - is there a close button ("x" in the top right corner)?
If not then open the form in design mode and set the "close button" property
to "yes".

Keith.
www.keithwilby.com
 
Thanks Allen, that has worked great. Weird thing is that I tried that
code before, and it didn't work. i tried it all again and now it
does...

oh well, i guess that's programming!

thanks for your help
 
Back
Top