Printing by use selected flag (1 Viewer)

Tupacmoche

Registered User.
Local time
Today, 04:23
Joined
Apr 28, 2008
Messages
291
I have used the wizard to create a print button which prints the current record with this VBA code:

DoCmd.OpenReport "CPM_Assignment_Detail", acViewPreview, WhereCondition:=" Id_Number = """ & Me.ID_Number & """"

I have added a bit field to a form so that users can 'check' which records they want printed as they review them. It is a check box called PrintFlag which has a default value of 0 (zero). I need help in the code to look for all the flags that have been set to 1 and print those records. Any help is appreciated.:confused:
 

Gasman

Enthusiastic Amateur
Local time
Today, 08:23
Joined
Sep 21, 2011
Messages
13,964
Try
Code:
WhereCondition:="PrintFlag = True"

HTH
 

Users who are viewing this thread

Top Bottom