Skip a Record in a report
Posted on 2002-05-05
I am looking for a .MoveNext command to go in Detail_Print
I have a report where I am printing address labels. The problem is, I need to skip certain addresses that are in the Report's recordset (don't ask why :) Unfortunately I can't sort by the AddressID due to restrictions in what I'm trying to do.
The way I need to do it is to create a string of all the AddressIDs separated by pipes (|123|324|67457|23|2342| etc.), As I print each label I send the AddressID for that label to a function that checks if the ID is still in the string. If it is, it returns true, removes the address from the string. If it's not, it returns false.
I am looking for the syntax for move next (don't print that label) if the function returns false (something like this):
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Not ShouldIPrintAddress(AddressID) Then
Thanks and I hope that made some sense