[AccessD] passing a value from report to form

Oleg_123 at xuppa.com Oleg_123 at xuppa.com
Mon Feb 2 15:59:17 CST 2004


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




More information about the AccessD mailing list