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 (http://www.access-programmers.co.uk/ubb/Forum4/HTML/003968.html) 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).