Form opened by another form

[Edwinq]

Hi,

Is there a way to check how the form was opened ??

meaning:
From form "main" I open up form "sub" with command
docmd.openform(sub"),,,,acDialog

WHen the sub form is open, can i check if it was opened by form Main ?

thanks in advance
Edwin

 

[boblarson]

Only if you pass that to the form at the time. You would have to include it in the OpenArgs

DoCmd.OpenForm "sub", WindowMode:=acDialog, OpenArgs:= Me.Name


Then you get the value when sub is open in the code for sub by using

Dim strFormOpenedBy As String
 
If Me.OpenArgs <> vbNullString Then
   strFormOpenedBy = Me.OpenArgs
End If

 

[Edwinq]

Worked great for me !

Thanks a lot

edwin