Results 1 to 2 of 2
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remember Form (A2000)

    Does any one have a function or module to remember the last form accessed.

    Some of my functions, on opening a form will close the previous form to conserve memory etc.

    I need a function that will call the form last accessed and open it.

    I know I can use the DoCmd option , but wondered if their was another solution.

    Dave

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Remember Form (A2000)

    You could do it with a function using either a static function or a function containing a static variable and simply pass the name of the form being closed as an optional argument into the function in the same routine that closes it. Then when you're ready to close the current form, you could call the same function without an argument and it would return the name of the form you passed in.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •