Using Checkbox "Visible" Property in Report

[Soup1]

Hi,

I am completely new to VBA coding in Access, so excuse me if my question is out of place.

I am trying to code a report that will gather information from two tables, a client table and a services rendered table. In the report, I only want to show those services where the checkbox has be selected for a given client. All other fields are to remain invisible. There are approximately 35 field that may be chosen. How can I do this? Any suggestions would be greatly appreciated.

"New to the hood and lost already"

 

[TrojanRabbit]

<control>.Visible = <checkbox>
You can put this in the report's Open event or the detail section's Format event.

 

[Soup1]

Hi,

Thanks for responding. However, I'm not quite sure what you're saying here. What exactly is to go in the <control> section? And am I to type the <checkbox> as it appears?

Oh, by the way, I'm using Access97.

Lost,