Returning to previous form

cmcritchie

New member
Local time
Today, 13:56
Joined
Sep 24, 2001
Messages
8
Hi,
I'm wondering if there is some VBA method to allow a user to close the current form & automatically reopen which ever form the user had open prior the current one. The reason is that the user may open this current form from a number of different forms & I need to know which one it was that they opened it from. Currently the only way I can achieve it is to leave the previous form open in the background and then just close the new one.

Thanks,
 
Check this it should provide you with a way of doing it. it's not clear if Irie got it working or not, but it certainly will,

Drew
 
I just leave the previous form open. Works well for me....
 
Thanks Drew - that works just as I needed.

Jack - the reason I don't want to leave
the previous ones open is that the newer forms are smaller than the previous + so it looks untidy to have them open in the background.
 
Just toggle the visible property of the forms, it's much easier.
 
Rich - Thanks, that's what Drew's solution does - however, the problem was knowing which form to make visible again after the new form was closed (but it's sorted now with Drew's solution).
 
Rich - Thanks, that's what Drew's solution does - however, the problem was knowing which form to make visible again after the new form was closed (but it's sorted now with Drew's solution).
 

Users who are viewing this thread

Back
Top Bottom