By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,871 Members | 2,575 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,871 IT Pros & Developers. It's quick & easy.

Thanks Everyone!

P: 48
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
Jun 9 '08 #1
Share this Question
Share on Google+
4 Replies

Expert 2.5K+
P: 3,532
Try opening the second form then closing the first form.

Expand|Select|Wrap|Line Numbers
  1. DoCmd.OpenForm "Form2"
  2. DoCmd.Close acForm, "Form1"
Linq ;0)>
Jun 9 '08 #2

P: 48
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
Jun 10 '08 #3

Expert 2.5K+
P: 3,532
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)>
Jun 10 '08 #4

P: 48
Thanks missinglink business doin pleasure as always lol.
Kind Regards Paul
Jun 11 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.