[AccessD] passing a value from report to form

I've done it for A97 and A2K.
Put it directly into the Control Source of the Object in the report.
For example:
I have a form with three date fields.  Begin Date, End Date and Annual
(picks the entire year)
I have one control at the top of the report for dates.  Below is what's in
the control source:

=IIf(IsNull([Forms]![frmRosterDatesSelect].[BeginDate]),"Calendar Year:
"+Str([Forms]![frmRosterDatesSelect].[AnnualYear]),"Between:
"+Str([Forms]![frmRosterDatesSelect].[BeginDate])+" -
"+Str([Forms]![frmRosterDatesSelect].[EndDate]))

HTH
Jim

-----Original Message-----
From: Oleg_123 at xuppa.com [mailto:Oleg_123 at xuppa.com]
Sent: Monday, February 02, 2004 3:59 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] passing a value from report to form


what version are we talking about ? and where should I put it. OpenArgs is
not available..

stDocName = "Carol2"
strSQL = "[employee number] = '" & Me!employeenumber & "'"
ddd = "[namee] = " & Me!Combo14.Value

DoCmd.OpenReport stDocName, acPreview, , strSQL







>
> Perry is correct.
> I do this all the time.
> This is especially useful to put the "To" and "From" dates for the
> report.
>
> Jim
>
> -----Original Message-----
> From: Perry Harold [mailto:pharold at proftesting.com]
> Sent: Monday, February 02, 2004 2:34 PM
> To: 'Access Developers discussion and problem solving'
> Subject: RE: [AccessD] passing a value from report to form
>
>
> How about ReportField=Forms![FormName]![FormField]
>
> Perry
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> Oleg_123 at xuppa.com
> Sent: Monday, February 02, 2004 2:18 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] passing a value from report to form
>
>
> Still can't figure out how to pass a value (not related to any table)
> user selects on a form to a report. Any suggestions ?
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> 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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com



-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com