Open Form in DataSheet View then Process on Close

[psycoperl]

Is there a way from form1 to open form2 in Datasheet view and then when form2 is closed to continue processing in form1?

form2 is "frmStudentBatchLoad"

on Form1 I have

Private Sub cmdOpenStagingArea_Click()

    DoCmd.OpenForm "frmStudentBatchLoad", acFormDS, , , , acDialog
    
    MsgBox DLookup("Count([Emplid])", "temptblStudentToLoad")
    
End Sub

When I click on the button that triggers the code I do not get the form opened properly, and the MSGBox appears automatically.

 

[Micron]

When you invoke a sub or function, you cannot expect it to stop processing at some arbitrary point. The command is processed (opens the form) and when that is done, it follows through on the next command as it is designed to do.

I do not get the form opened properly,

If you don't specify a view in code, it defaults. Make data sheet the default view in design mode and simply open the form to get data sheet view. Anything you don't want to happen until the second form closes would have to either
- be coded in that form close event
- call code from a standard module
- or some trick that you can trigger in code but would not likely be effected (yes I meant effected, not affected) by the user. This would be my very last choice.