morning all,
hopefully someone has a creative solution for this query.
within my db users can have multiple forms open at one time and there is the possibilty of there being data in multiple recordsets.
rather than just walking backwards through the opened forms and recorsets they also want to be able to go straight back to the main menu.
with RoyV's post for another user from another thread (thread705-861049) and the faq listed in it. i'm able to, pretty much, dynamically walk through the posible opened forms and close them.
is there a way to do this for a record set? or am i stuck with:
pseudo code
if formx is loaded then close rstx.
if formy is loaded then close rsty.
any suggestions?
regards
longhair
hopefully someone has a creative solution for this query.
within my db users can have multiple forms open at one time and there is the possibilty of there being data in multiple recordsets.
rather than just walking backwards through the opened forms and recorsets they also want to be able to go straight back to the main menu.
with RoyV's post for another user from another thread (thread705-861049) and the faq listed in it. i'm able to, pretty much, dynamically walk through the posible opened forms and close them.
is there a way to do this for a record set? or am i stuck with:
pseudo code
if formx is loaded then close rstx.
if formy is loaded then close rsty.
any suggestions?
regards
longhair