 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / November 2005Identifying a popup's "root" form
Using Access 2003 I have a popup that I access from several different forms. When a change is made to this popup and it's closed, I would like it to requery the root form it was opened from (which contains some of the data). I know how to do this by simply naming the forms and giving them a requery command, however, I don't know a way to identify the root form. If I could do this in code, it would clean up the script and get rid of some errors (ie. an error telling me a certain form isn't open). So, what is the best way to identify the root form of a popup via VB? TIA Aaron G Philadelphia, PA If what you are asking is how do I know what form opened the popup, then you could pass the name of the opening form in the OpenARgs argument of the OpenForm method. Then in the popup, you will know which form open it: txtWhoOpenedMe = Me.OpenArgs > Using Access 2003 > [quoted text clipped - 13 lines] > Aaron G > Philadelphia, PA >So, what is the best way to identify the root form of a popup via VB? About the only way I can think of would be to pass the calling form's Name in the OpenArgs argument of the OpenForm event. In general, a form doesn't keep any record of how or whence it was opened. John W. Vinson[MVP] That will do it. Thanks to both of you. Aaron G Philadelphia, PA > >So, what is the best way to identify the root form of a popup via VB? > [quoted text clipped - 3 lines] > > John W. Vinson[MVP] >> So, what is the best way to identify the root form of a popup via VB? > > About the only way I can think of would be to pass the calling form's > Name in the OpenArgs argument of the OpenForm event. In general, a > form doesn't keep any record of how or whence it was opened. Here's an alternative: in the popup form's Open event, Screen.ActiveForm is still the form that had the focus before the popup was opened. I can imagine how this might fail, though, if some other form's Timer event fires between the "root" form's call to DoCmd.OpenForm and the popup form's checking of Screen.ActiveForm.  SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.