View Single Post
Old 09-15-2019, 10:44 PM   #1
Newly Registered User
Join Date: Aug 2019
Posts: 43
Thanks: 16
Thanked 0 Times in 0 Posts
GoodyGoody is on a distinguished road
What Report level fields are available to the 'On Print' event

Hi, I have a query with a number of columns that aren't printed on the report line but that I was to save to table for each line on the report. In the 'On Print' event I can successfully pick up this particular field (Me.RaceEventID as it happens) from the drop down that appears so Access VBA knows it's in the collection but when I actually run the report VBA gives an error saying it can't field the field Me.RaceEventID. I'd like to know why this is and so is the only work around to 'print' the field on the line but to hide it for printing to to make it explicitly visible to the 'On Print' event? Thanks as usual for any help.

GoodyGoody is offline   Reply With Quote