check box data in report..

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

How can I display data for checkbox in the report if that checkbox is
checked as yes? I mean..if no checkbox is checked none should be displayed in
the report and if user checks..say one or two checkboxes in the form..I want
them to be displayed in the report.

How can I do that? Please help me.

Thanks
 
Can you be a lot more specific? Display what when a check box is checked? Is
the Yes/no field in a record that you want to display or hide another field
in the same record? What does the form have to do with the report? Does it
only affect the layout in the report?
 
Hi Duane,

I am generating a report based on the selections I make in the form and
query runs behind it (where it looks for the criteria being selection in the
form). In the form I have combo boxes, checkboxes fields. For checkboxes I
would like to do something like this:

say..I have two checkboxes: BA; MA .

If I check BA in the form I should see records with BA degree as checkbox
checked in the report (here I don't want to see MA checkbox because its not
checked int eh form). And on the other hand if I check MA I just want to see
MA checkbox in the report as checked with other personal info. IN the second
case, I don't want to see BA checkbox in the report. I want a check box to be
visible in the report only when user checks that checkbox in the form
otherwise not.

Hope I clarified little bit more..

Thanks
 
I assume the controls on the form are not bound to fields in a table. Do you
want to display or not display "records" in a report based on user
selections on the form OR do you want to hide controls in the report based
on user selections on the form?
 
I am creating unbound fields in the Form where I am making selections. I want
to display the records based on the selections made on the form PLUS I also
want to hide checkboxes on the report if its not checked in the form. eg:

If a person has a MA degree and PhD. But if user selects PhD only on the
form it will display his/her personal info plus a checkbox for PhD only as
checked. But on the other hand if user checks both MA and PhD then report
should show two checkboxes one for MA and other for PhD as checked. Third, If
user doesnot check any of the checkboxes in the form I don't want any check
boxes to be shown in the report.

Is it possible to do this? I would really appreciate y our help on this.
Thanks
 
You can use code in the On Format event of a report section that sets the
visible property of a control to either true or false depending on the value
of a control on a form. For instance:
Me.chkPHD.Visible = Forms.frmRunReport.chkShowPHD
 
Back
Top