Charlotte Foust
cfoust at infostatsystems.com
Mon Jun 16 16:36:02 CDT 2003
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