pass parameter to report

I want to write a button which will trigger a specific report required a
parameter. How can I pass a parameter to report using the access code?

On Wed, 23 Nov 2005 12:13:59 +0800, " -00Eric Clapton"
wrote:

I want to write a button which will trigger a specific report required a
parameter. How can I pass a parameter to report using the access code?


Base the Report on a Query using the parameter as a criterion.


John W. Vinson[MVP]

OK. In coding, what is the syntax to pass the parameter to the query and
how to run the report with passed parameter? Thanks.


"John Vinson" wrote in message
news
On Wed, 23 Nov 2005 12:13:59 +0800, " -00Eric Clapton"
wrote:

I want to write a button which will trigger a specific report required a
parameter. How can I pass a parameter to report using the access code?


Base the Report on a Query using the parameter as a criterion.


John W. Vinson[MVP]

Can anyone please help?


" -00Eric Clapton" wrote in message
...
OK. In coding, what is the syntax to pass the parameter to the query and
how to run the report with passed parameter? Thanks.


"John Vinson" wrote in message
news
On Wed, 23 Nov 2005 12:13:59 +0800, " -00Eric Clapton"
wrote:

I want to write a button which will trigger a specific report required a
parameter. How can I pass a parameter to report using the access code?


Base the Report on a Query using the parameter as a criterion.


John W. Vinson[MVP]

On Wed, 23 Nov 2005 13:53:22 +0800, " -00Eric Clapton"
wrote:

OK. In coding, what is the syntax to pass the parameter to the query and
how to run the report with passed parameter? Thanks.

What's the context, Eric? Where is the parameter coming from?

One thing you could do, if the parameter is available within VBA but
not (readily) on a Form or other source, is actually construct the
Report's SQL string in code and set its Recordsource property to the
string.

Or, use the WhereCondition parameter of OpenReport:

Dim strSQL As String
strSQL = "[fieldname] = " & TheParameterValue
DoCmd.OpenReport "rptMyReport", WhereCondition := strSQL

John W. Vinson[MVP]

I put a parameter in select query and create a report which recordsource is
this query. Also write in code as the following suggested, but when I run
the following code. It keeps asking me the parameter value in the query even
after I set the theparametervalue = constant. Please help. THanks.


"John Vinson" wrote in message
...
On Wed, 23 Nov 2005 13:53:22 +0800, " -00Eric Clapton"
wrote:

OK. In coding, what is the syntax to pass the parameter to the query and
how to run the report with passed parameter? Thanks.

What's the context, Eric? Where is the parameter coming from?

One thing you could do, if the parameter is available within VBA but
not (readily) on a Form or other source, is actually construct the
Report's SQL string in code and set its Recordsource property to the
string.

Or, use the WhereCondition parameter of OpenReport:

Dim strSQL As String
strSQL = "[fieldname] = " & TheParameterValue
DoCmd.OpenReport "rptMyReport", WhereCondition := strSQL

John W. Vinson[MVP]