[AccessD] Skip record in report

Hi Susan

IIRC you can just set

Cancel=True

in the OnPrint or OnFormat

Andy Lacey

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
Beach Access Software
Sent: 20 January 2009 20:48
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Skip record in report


I use:

If (SkipCondition - whatever it is) = True Then
	Me.MoveLayout = False
	Me.NextRecord = True
	Me.PrintSection = False
End If

In the Format event of the Detail section.


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Tuesday, January 20, 2009 12:34 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Skip record in report



> Would you not  remove that record(s) from the underlying recordsource
> before invoking the report?

=====Well, I wasn't going to, as a point of illustration, but decided to
skip that discussion. :)

Susan H. 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com