Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Forms Coding > Can pass subfor...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 7 Topic 41561 of 43412
Post > Topic >>

Can pass subform Recordsource to a Re****t

by =?Utf-8?B?RmVkZXJpY28=?= <Federico@[EMAIL PROTECTED] > Aug 8, 2008 at 06:02 AM

I have a form where two listboxes filter data so a subform quickly displays

filtered records. Coding allows for multiselect, and a SQL string is 
generated and applied to the subform recordsource:

       Forms!ReviewSamplesResult!Details.Form.RecordSource = strSQL

Since the user needs to be able to print this subform data, I created an 
OpenRe****t command button.

How can I pass the SQL that was built to generate the data for the re****t?
I tried things like
-----------
Dim strLinkCriteria As String

stDocName = "rptReviewSamplesResult"
strLinkCriteria = Forms!ReviewSamplesResult!Details.Form.RecordSource
DoCmd.OpenRe****t stDocName, acPreview
-----------

but did not fly. I am not very familiar with using OpenArgs and was 
wondering if it could be a way to pass the data. also, don't you need to 
provide the RecordSource BEFORE the Re****t opens?

Thanks for help.

Federico
 




 7 Posts in Topic:
Can pass subform Recordsource to a Report
=?Utf-8?B?RmVkZXJpY28=?=   2008-08-08 06:02:01 
Re: Can pass subform Recordsource to a Report
Marshall Barton <marsh  2008-08-08 09:31:48 
Re: Can pass subform Recordsource to a Report
=?Utf-8?B?S2xhdHV1?= <  2008-08-08 07:45:00 
Re: Can pass subform Recordsource to a Report
Marshall Barton <marsh  2008-08-08 13:50:17 
Re: Can pass subform Recordsource to a Report
=?Utf-8?B?RmVkZXJpY28=?=   2008-08-08 12:06:01 
Re: Can pass subform Recordsource to a Report
=?Utf-8?B?RmVkZXJpY28=?=   2008-08-08 07:50:01 
Re: Can pass subform Recordsource to a Report
Marshall Barton <marsh  2008-08-08 13:55:36 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:53:16 CST 2008.