Yes/No control box

[Frederic]

Hi Folks,

How can I have a control "Yes/No" on a form that once the checkbox is checked
that do not show the line record on my report

Thanking you in advance for your answer
Fredderic

 

[Al Campagna]

Fredrick,
Create a field in your table called something like NoPrint, and make it a
Yes/No (True/False).
Place that field on your form. If the field is checked (True), then that
record will be excluded from your report.

In the query behind your report, use a criteria against the NoPrint
field...
= False
That says... show me only records where NoPrint is False.

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."