[AccessD] OpenArgs question

In AXP, reports DO have an OpenArgs parameter.

Charlotte Foust

-----Original Message-----
From: Heenan, Lambert [mailto:Lambert.Heenan at AIG.com] 
Sent: Monday, June 16, 2003 1:08 PM
To: 'accessd at databaseadvisors.com'
Subject: RE: [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
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com