[AccessD] OpenArgs question

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


More information about the AccessD mailing list