Thanks Everyone!

[panteraboy]

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]

Try opening the second form then closing the first form.

DoCmd.OpenForm "Form2"
DoCmd.Close acForm, "Form1"

Linq ;0)>

[panteraboy]

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

[missinglinq]

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)>

[panteraboy]

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