How to suppress printing a record? Access2007

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
it's called a WHERE CLAUSE.

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

-Aaron
 
Rick said:
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?
Click to expand...

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.
 
Back
Top