dynamic recordsource on report

[rry2k]

I would like to set a recordsource on a subreport depending on an which option button is clicked. I've done this on forms but not reports. I can't seem to get the syntax correct. Is it something like Reports![Time Sheet Subreport].recordsource??

Thanks for the help..Russ

 

[LonnieJohnson]

You can create a query for the subform, then use the Query Def object to dynamically set the query criteria when you choose an option.

prodevmg@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

May God bless you in the year 2002.