Personal address database book

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
Click to expand...

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