[AccessD] OpenArgs question

Reports don't have an OpenArgs property, and there is as a result no
OpenArgs parameter for the OpenReport method. OpenReport does however have a
"wherecondition" parameter and that's the one you want to use. It's a
standard SQL WHERE Clause without the word 'WHERE' - see the on-line help.

Lambert

> -----Original Message-----
> From:	Susan Harkins [SMTP:harkins at iglou.com]
> Sent:	Monday, June 16, 2003 4: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