Newbie...VBA

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

Hello. I have a report whcih has several fields that are
check boxes and need some help. I would only like the
fields checked yes to show up with the label and another
label which acts as a "header." Only one box from each
of the three sections can be checked. For example:

Approved documents:

CDRL Contract Mod Drawings
x

Gov/Contractor Review:

Risk SOW Spec


IPT Working Group:

PM-IPT CHWG P-IPT

So if only the CDRL box is checked I'd like that label,
the check box and the above heading "Approved Documents"
to show up on the report. This might be too confusing so
if anyone is aware of good websites that can help I'd be
very thankful.

Jeff
 
Personally, I would arrange your data in a slightly different manner.
First, you have a table with three fields: documents, review, IPT.
Each of these gets its values from a lookup table.
For example, your document table has an autonumber (the key) and a
description (CDRL/CONTmod/drawings)
The description can be as long as you like.

Instead of using a checkbox, you have a drop down list with those choices
for each.
When you print the report, you have "Approved Documents" and the value of
that entry.

The tables and the relationships will be easy to set up and will in all
likelihood be established
automatically by the program through the use of the lookup wizard.

Scott
 
Thanks Scott. I will make the changes you suggested.
Your way seems to be more practical.

Jeff
 
Back
Top