Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic find of recordsets with data

Status
Not open for further replies.

longhair

MIS
Feb 7, 2001
889
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top