Opening more than one form (Not Multiple Instances of the Same form)

[ETCallHome]

Hi,

I tried searching for help, but the search just brings up multiple instances of the same form. Here is what I would like to accomplish. I open form frmA and the user selects a record and want to modify the record. But before opeing the form frmB to modify the record, I want to direct the user to another form frmC first to enter the reason they are modifying the record. Below a sample code in frmA:

if modify then docmd.openform "frmC"
docmd.openform "frmB"

what happens is that it opens form frmC and immediately opens frmB. Form frmB is the one visible to the user, this means the user can then modify the record without entering the reason for modifying. When they exit, form frmC is visible and they can then exit without entering the reason.



There are different ways that I can accomplish this, but it makes sense to do it this way, the only catch, how do I open form frmC and only after the user exits then form frmB opens. I made both forms modal, as I am under the impression that a modal form will wait for user interaction before executing the next line of code... it seems my assumption has proved me wrong..

If there is a way, I would appreciate the help, else I will have to then open frmB and when the user exits, open form frmC and force the user to enter the reason.

Another problem I have is that every now and then the form opens in a different size, i.e. Popup forms. One moment it is fine and the next moment it opens smaller than the form size stipulated. Is there anyway I can ensure that this does not happen, because I have to save the forms again and then it works fine...

Thanks
Earl

[ketbdnetbp]

You could set the modal property of formC to Yes. Then in the after update event of the reason field on formC, if it is not null and is a valid entry, DoCmd.OpenForm "formB" and DoCmd.close "formC".

Edit: You might also want to remove the close button as well as min/max buttons on formC.

Just a thought.

Jim

[ETCallHome]

Hi,

Thanks for the advice, but I landed up passing the form name that is calling the form as a parameter to form FrmC and when the user enter the save/add button, I check if the form name passed across is FrmB, then after the add/save of the record, I open FrmB.

Earl