Thanks Everyone!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • panteraboy
    New Member
    • Apr 2008
    • 48

    Thanks Everyone!

    Hi there again byters. I would just just like to extent my gratitute to every one who helped me construct my first database in the real world lol. I found this site my guiding light amongst all the darkness. Just one more wee question though .When i a user clicks on a button to go to another form. I use a close method followed by the docmd.openform" relevant form". This causes a tempory flicker and i was wondering how to close the previous form from the active form. Though it would be Screen.previous .close but method doesent exist.

    Kind Regards
    Paul
  • missinglinq
    Recognized Expert Specialist
    • Nov 2006
    • 3533

    #2
    Try opening the second form then closing the first form.

    Code:
    DoCmd.OpenForm "Form2"
    DoCmd.Close acForm, "Form1"
    Linq ;0)>

    Comment

    • panteraboy
      New Member
      • Apr 2008
      • 48

      #3
      Hi missinglinq, good to here from ya again. That would work fine if it was just one form that led to the current form but I can arive at my current form from a no of different forms. So I need a way of finding the previously opened forms name and close it or keep looking though the libraries till i find a method lol . Thanks anyway
      Regards Paul

      Comment

      • missinglinq
        Recognized Expert Specialist
        • Nov 2006
        • 3533

        #4
        So pass the name of the calling form (Me.Name) to the second form thru OpenArgs of the form open command, then retrieve the name passed in the second form and close it.

        Linq ;0)>

        Comment

        • panteraboy
          New Member
          • Apr 2008
          • 48

          #5
          Thanks missinglink business doin pleasure as always lol.
          Kind Regards Paul

          Comment

          Working...