Using a command button to open a form

[mgbeye]

I am working with two forms. I want to put a button on each form That will close the current form and open the other. The forms use queries to pull the records that can be accessed. Can anyone help??

Thanks

 

[tlbroadbent]

In the click event of each button put the following.

DoCmd.OpenForm "other_form_name"
DoCmd.Close acForm, "This_form_name", acSaveYes
Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot