building a report with the use check boxes help

[Mark]

Hello...

Thanks for looking at this. I run a military medical clinic and I want to
build a patient health care hand out report application. What I would like
to do is have a custom screen, where my technicians click on check boxes
which are linked to a record in a table or maybe a word document and then
have Access build a custom tailored patient information handout. The report
I envision will be built in sections, so we do not kill trees or waste yours
and mine tax dollars by printing an individual pages for maybe a couple
lines of text. Will Access do this type of thing? I am familiar with Access
but not to the level that I think that this will take. Any help or examples
will be appreciated.



Mark

 

[Duane Hookom]

You could have a table of handout information with at least fields for:
InfoID autonumber Primary Key
InfoTitle Short Description
InfoText Memo field to include in a report

You can then use a multi-select list box based on the Info table to allow
users to click multiple titles. This can add records to a table which can
serve as the Record Source of a report.