Sub report VBA not firing when loaded through main report (1 Viewer)

Juett · Oct 4, 2019

Hi Guys,

I have a little issue with some VBA code in a sub report.

The following code works in the sub report when opened directly:

Code:

Private Sub Report_Load()
If IsNull(cmb1.Value) Then
    Me.img1.Visible = False
Else
    Me.img1.Visible = True
End If
End Sub

It displays or hides an image based on the value of a combo box.

But...when I insert this report as a sub report in another (main form) and open it, the code does not fire.

What do you think I might be missing?

Thanks very much.

arnelgp · Oct 4, 2019

reports event don't fire when inserted as subreport.
set it on the main reports load event:

private sub report_load()
me.subreportname!img1.Visible = (IsNull(me.subreportname!cmb1)=False)
end sub

Juett · Oct 4, 2019

That worked perfectly, thanks very much!

arnelgp · Oct 4, 2019

you are welcome!

Sub report VBA not firing when loaded through main report (1 Viewer)

Juett

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Juett

Registered User.

arnelgp

..forever waiting... waiting for jellybean!

Similar threads

Users who are viewing this thread