Combo Box to Open Report

[angie]

Hi I have three reports that I would like to use on a form [I would like a form that has a subform that is controlled by a combo box to select the reports to show up in the subform]


Thanks

[June7]

Options:

1. a subform/subreport container control for each report and code sets Visibile property

2. code sets the ControlSource property of subform/subreport container control

3. just open the report independent of form

[angie]

I have to make it easy for co-workers we share the database over a network
could you explain option 1 and 2. Thanks.

[June7]

Do you have an understanding of programming for Access? If you do, what I described is fairly straightforward. A subform/subreport is created by installing a subform/subreport container control on another form. That container control has properties that can be managed with code. I use only VBA, not macros.