Returning to menu from different forms

[Gazza2]

I have menus for different users but they contain some of the same forms.

the code i use at the moment is

select case keycode
case vbkeyescape
keycode = 0
docmd.close
docmd.openform"main menu"
end select

this is in the onkeydown event of the form and works ok to open the main menu and close the form when the escape key is pressed but i need it to open the users own menu.is it possible to get it to go back to the previous form(All users menus are forms whichuse the username as the formname)

thanks

 

[wiltshire]

A simple way to do it would be to make all forms pop-up, these just open on top of each other. Then, when you close the top form down, the one below it will show.