Which form opened this report?

[cyberdwarf]

Hi,

Being very dumb today!

I need to know, in VBA code, which form was used to call a report (using DoCmd.OpenRepor t)

Must be some sort of method or property to do this???

TIA

Steve

[ADezii]

Hi,

Being very dumb today!

I need to know, in VBA code, which form was used to call a report (using DoCmd.OpenRepor t)

Must be some sort of method or property to do this???

TIA

Steve

Use the OpenArgs Property of the OpenReport Method as in:

Dim stDocName As String

stDocName = "rptEmployee"
DoCmd.OpenReport stDocName, acPreview, , , acWindowNormal, "My Form Name"

Then, in the Report's Open() Event, place code similiar to this. This should point you in the right direction.

Private Sub Report_Open(Cancel As Integer)
If Not IsNull(Me.OpenArgs) Then
  MsgBox "Form " & Me.OpenArgs & " opened this Report"
End If
End Sub

[cyberdwarf]

Hi, ADezii


Thx for your response.

Unfortunately, the OpenArgs property is already in use for other purposes ;-(

Ho hum

Steve

[ADezii]

Hi, ADezii


Thx for your response.

Unfortunately, the OpenArgs property is already in use for other purposes ;-(

Ho hum

Steve

How about assigning a Public Variable representing the Form's Name when it is opened. It can then be read anywhere within the Project?

[NeoPa]

I don't think there is a prescribed way to do this I'm afraid Cyber.
ADezii's idea is probably the best you'll get.