Good catch on not needing the quotes for acDialog. However, I still count the windowmode argument as the 6th argument, even in your OpenForm statement below.
Toby ----- Original Message ----- From: "Oller Robert W SrA 30 SCS/SCXM" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Friday, August 05, 2005 9:19 AM Subject: RE: [AccessDevelopers] Re: looking for an event One note on Toby's message, don't use the quotes on acDialog and it is the Fifth argument. Command should look like this: DoCmd.OpenForm "frmWhatever",,,,, acDialog When you type your code into VBA, the screen tip will show you what argument you are on and when you come to acDialog argument, it will show you a list of options. //SIGNED// Robert W. Oller, SrA, USAF -----Original Message----- From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Toby Bierly Sent: Friday, August 05, 2005 9:10 AM To: AccessDevelopers@yahoogroups.com Subject: Re: [AccessDevelopers] Re: looking for an event I think your answer is to open the form with a dialog windowmode. This is the 6th argument that you can specify in an OpenForm statment. DoCmd.OpenForm "FormName",,,,,"acDialog" I believe this "freezes" the code in the calling form until the dialog form is closed. HTH, Toby ----- Original Message ----- From: "dreaux1" <[EMAIL PROTECTED]> To: <AccessDevelopers@yahoogroups.com> Sent: Thursday, August 04, 2005 10:12 PM Subject: [AccessDevelopers] Re: looking for an event Bob suggests ... > Just add more > code to the click event. Is this what you are looking to do? Thanks Bob, and .. Yea .. that's what I'd like to do, but all the code in the click event gets run before the the DoCmd.OpenForm line that launches the new form, even if sequentially the code actually follows the DoCmd line. I think that's pretty much how all the windows-basics work. The result is that when Form-B closes, Form-A resumes at the end sub point of the Form-A click event. I also tried it with creating a new sub and moving the DoCmd.OpenForm line to the new sub, and then call the new subroutine from within the Onclick event. The result is the same. Jeb > Hello, > > I'm back to programming ... hopefully for the rest of the year !!! :) > > > Q: From one form (Form-A) I launch a pop-up/modal form (Form-B). > After Form-B gets launched I'd like to find a Form-A event (or > something like an event :) ) for when the pop-up (Form-B) gets > closed and Form-A again has the focus. Apparently there is no such > event, and from within the Form-A code-flow it's like the pop-up > never happened. > > I imagine I can attach to the close event of form-B, but I'd like to > stay within the confines of Form-A. Hopefully it's something obvious > I'm missing. > > Thanks in advance. > > Jeb Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links Please zip all files prior to uploading to Files section. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hrrmka2/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123266417/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org ">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life - brought to you by One Economy</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
