Go to another form

[Guest]

Hi.
This should have been easy but it is not working. I go from form1 to form2
(openform command). I do not close form1. When the user clicks on a button on
form2 I want to go back to form1, which is still open. I do not want to close
form2. I have tried to use setfocus to go back to form1 but that does not
work. Does anyone know how to do this?
Thanks!

 

[tina]

try using

DoCmd.SelectObject acForm, "MyFormName"

substitute the correct name of form1, of course.

hth

 

[Guest]

You are brilliant! Thank you! Thank you! Thank you!
It works great.

 

[tina]

you're welcome

You are brilliant! Thank you! Thank you! Thank you!
It works great.