[AccessD] OpenArgs question

Susan Harkins harkins at iglou.com
Mon Jun 16 16:50:56 CDT 2003


OK, I'm using AXP.

I'm selecting a single item from a list box and trying to pass that value (a
string) to the report via the report's OpenArgs value.

Susan H.


> Susan,
>
> I'm getting confused.  Where are you trying to recognize it, and where
> does a form come into the equation?  Only A2002 has an OpenArgs argument
> for reports.  Earlier versions didn't have it.  We use it in reports
> without problems, so what are you trying to do that isn't succeeding?
>
> Charlotte Foust
>
> -----Original Message-----
> From: Susan Harkins [mailto:harkins at iglou.com]
> Sent: Monday, June 16, 2003 12:50 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] OpenArgs question
>
>
> This should be an easy one. The following event procedure opens a report
> and passes the list box' value as th OpenArgs setting.
>
> Private Sub lstCategories_DblClick(Cancel As Integer)
>   Dim str As String
>   str = Chr(34) & Me.lstCategories.Value & Chr(34)
>   Debug.Print str
>   DoCmd.OpenReport ReportName:="Catalog", _
>       View:=acViewPreview, _
>       OpenArgs:=str
> End Sub
>
> Problem is, I can't get the report to recognize it -- in any report
> event.
>
> Reports!reportname.OpenArgs
> Me.OpenArgs
> rpt.OpenArgs
>
> I've tried all three in most of the report's events after opening it via
> the form and the setting isn't making it to the form. Any clue what I'm
> doing wrong?
>
> Susan H.
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>



More information about the AccessD mailing list