Check box question

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

On a form, if I have a checkbox checked I then want to print the word VOID
on my report showing the same record. Also, this is a subreport so I want to
count the number of VOID's (checked boxes) and bring total over to main
report.

This comes from a table with all fields including the checkbox. I then use a
query for the form and report.

Thanks.
rob
 
Place a textbox on the main report and set its Control Source to

=DCount("[FieldName]", "Table Name", "[FieldName]=True")

In the subreport, place a label with the word VOID as its caption where you
want the word to print in the section of the report. In the OnFormat event
of the section set the Visible property of the label to the value of the
checkbox field.
 
Back
Top