[AccessD] Setting Sub Report Recordsource via VBA

What precisely are you trying to accomplish and *when* are you trying to
set the recordsource?

Charlotte Foust

-----Original Message-----
From: jeffrey.demulling at usbank.com [mailto:jeffrey.demulling at usbank.com]

Sent: Tuesday, June 01, 2004 11:51 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Setting Sub Report Recordsource via VBA






I am trying to set a subreport's recordsource via a VBA and cannot seem
to get it correct.

I have tried:

me.<<subreportname>>.Recordsource = finalsqltext

Reports!<<parentreportname>>!<<subreportname>>.Recordsource =
finalsqltext

and neither one seems to be working.

Can anyone help????


-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com