Command button and SubReport

[cathyg18]

I want a subreport to open only when a command button is pushed to open it, and have the subreport correctly connected to the current record in the main report. I have been able to either insert the subreport and have the records correctly connected, but always visible; or insert the command button to open the subreport on request, but show all records in the subreport, not just those related to the visible record in the main report.

Any ideas?

TIA, Cathy

 

[RottPaws]

How about if you set the visible property of the sub to false and then have the command button set it to true? _________
Rott Paws

...It's not a bug. It's an undocumented feature!!!

 

[cathyg18]

This works perfectly! Thanks for the help.