VBA Checkbox code ticking all records on report. How to target individual records?

[Garindan]

Sorry for the long title.

I have the following code in the On Load of a report which shows multiple records:-

If Me.PaymentType Like "Debit/Credit Card" Then
    Me.Check94 = True
Else
    Me.Check94 = False
End If

This ends up checking all check boxes in the report if any have "Debit/Credit Card" in the PaymentType field.

What I wanted was to tick Checkboxes for those records where the statement was true, and not tick those where it is false.

Do I need the code in the On Current event? Or do I need more sophisticated code?

Many thanks for your help!

 

[David R]

I think you can skip the code entirely, if what I understand of what you want is accurate.

In the query behind the report, put in a calculated field:

PaidByCard: IIF([PaymentType] = "Debit/Credit Card", True, False)

Then in your report, just put a checkbox based on that calculated field, and you should be good to go.

 

[Garindan]

Brilliant. Thankyou to both of you! I have used Davids method and it's working perfectly. Thanks again!