Button with two events

[Dreamer]

Hello Everybody

I need to create a button that:

1- Close the form to which belongs
2- Open another form neither or closed the previous one.

Thanks!

 

[Guest]

Hi Dreamer -
I use Macros a lot to do this. Create a macro with 2 lines
OpenForm - name of form to open
CloseForm - name of form to close
Then create your button, choose the Misc category and Run Macro action.
Choose the macro you created.
Hope this gives you what you need.
Yours - Dika

 

[Dreamer]

Thanks for answer!

I need do this without Macros... Its possible?

Thanks!

 

[Guest]

Hi Dreamer - you can do it with Code. Why not with macros?

 

[Guest]

Hi again - code would be something like this

DoCmd.OpenForm "form to be opened", acNormal, "", "", , acNormal
DoCmd.Close acForm, "form to be closed"

 

[DREAMER]

Thank you very much Kernow Girl!!

I use only code, because I distribute the application to several users who have different OS and different versions from office, and have experienced some problems with macros.

Thanks!

Dreamer.-

--------------------------------------------------------------------------------

 

[Guest]

Hi Dreamer - glad that helped. By the way, I may be teaching you to suck
eggs, but when I do use code I create the Macro first (my background is not
in coding) to get the commands and logic flow and then Save as Module. It
then shows we what the code is and I can slot it in where needed.

yours -- Dika