I have created a report that generates based on a persistent query.
What we would like to do is be able to add or remove certain fields
from the report as required by a form.
We would like to use a check box for each field.
That is, the report would create itself based on the checkbox values.
The report is not a datasheet which adds a tougher twist.
Any ideas on this. Or are we dreaming the impossible dream.
Thanks
Will
Duane Hookom - 25 Jan 2007 04:32 GMT
Assuming your check boxes are controls on a form...you could add code to the
On Format event of your report section containing the controls like:
Me.txtFirstName.Visible = Forms!frmYourForm!chkShowFirstName

Signature
Duane Hookom
Microsoft Access MVP
> I have created a report that generates based on a persistent query.
>
[quoted text clipped - 11 lines]
> Thanks
> Will