Personal address database book

[Guest]

Hi,

In the template "personal address database book" from the Office website
there is a report where they selectively show records based on a value in a
check box (send card). They do not use a query. How is this done ?
I have created a report with labels and if the value in the check box is
"yes", then the label should appear on the report. Otherwise not.

Thanks
Kurt.

 

[fredg]

Hi,

In the template "personal address database book" from the Office website
there is a report where they selectively show records based on a value in a
check box (send card). They do not use a query. How is this done ?
I have created a report with labels and if the value in the check box is
"yes", then the label should appear on the report. Otherwise not.

Thanks
Kurt.

I haven't looked at the template, but....
Open the report using a command button on a form.
Code the click even:
DoCmd.OpenReport "AddressReport", acViewPreview, , "[CheckBoxName] =
-1"

Another way is to set the Report's Filter property to:
[CheckBoxName] = -1
Set the FilterOn property to True

Both are on the Report Property sheet's data tab.

The first method is more flexible.