How to suppress printing a record? Access2007

[Rick]

Is there a way in VBA to suppress printing a record? I have created a select
query and want to display missing data to the user. In the Detail_Format I
examine each record and, if it has no missing data, would like to suppress
printing and move to the next record.
I can't seem to get the reportobject.nextrecord or the Cancel=True to work.
Is there another method?

Thank you.
.... rick

 

[a a r o n . k e m p f]

it's called a WHERE CLAUSE.

don't show the records (in the SQL Statement) you don't want to print.

-Aaron

 

[John W. Vinson/MVP]

Is there a way in VBA to suppress printing a record? I have created a
select query and want to display missing data to the user. In the
Detail_Format I examine each record and, if it has no missing data, would
like to suppress printing and move to the next record.
I can't seem to get the reportobject.nextrecord or the Cancel=True to
work.
Is there another method?

Why not modify the query - or create a new one - to select only records with
missing data???

Reports aren't "procedural" in the sense you're assuming.