Checking a box on a report

[Guest]

I think there must be a simple way to do this, but I can't figure it out. I
have a report that must match a printed form. On the report, each record
needs one of about 12 checkboxes checked and all the rest blank. The value
that determines which box to check is the combination of two field values,
stored in different tables. I have named each box based on this value. I want
to calculate the value of the correct box, then set its value to true. Is
there a way to set the report's checkbox to true from a proceedure?
-rg

 

[John W. Vinson]

I think there must be a simple way to do this, but I can't figure it out. I
have a report that must match a printed form. On the report, each record
needs one of about 12 checkboxes checked and all the rest blank. The value
that determines which box to check is the combination of two field values,
stored in different tables. I have named each box based on this value. I want
to calculate the value of the correct box, then set its value to true. Is
there a way to set the report's checkbox to true from a proceedure?
-rg

I'd use a Query joining the two tables as the recordsource for the form. You
can have twelve calculated fields in the table such as

Check6: [Thisfield] = "X" AND [Thatfield] > 0

using whatever expressions define the truth or falsity of the checkbox.

You sholdn't need any code, and the name of the checkbox is irrelevant.

John W. Vinson [MVP]