I want a check box on an Access form to create a Note on a report

[trigger]

I would like to have someone either check a box or pull a note from a drop
down list that would then print on my report. i.e. if the box is not
checked, no note would print.

 

[Larry Linson]

I would like to have someone either check a box or pull a note from a drop
down list that would then print on my report. i.e. if the box is not
checked, no note would print.

What you want to do is certainly possible. If you could be a bit more
specific in your request, we could be a bit more specific in our answer.
Where on the the Report do you want the information to print; is the
information stored in a Table in your Database or ???; do you want it to be
printed once (and, if so, where: Report Header, Page Header, Page Footer, or
Report Footer), or for each Record?

By the way, what version of Access are you using?

Larry Linson
Microsoft Office Access MVP