Take param from form (repost)

[Rajat]

Hi,

I have a report with recordsrc qry4.

qry4 calls qry3 which calls qry2 which finally calls qry1.

qry1 has a parameter called [Report Client], and I am
prompted for its value and everything works fine.

Now I would like to run the report from a form, such that
the report takes the parameter from the current selection
on a lstbox on the form.

The criteria in qry1 is:
[Report Client] or "any"

I tried making it:

[Forms]![frmReportClient]![lstReportClient] or "any"

but instead of just taking the value from the form, it
again prompts the user for it.

I even renamed the parameter to:
[Forms]![frmReportClient]![lstReportClient]

but with no luck!

Any ideas?

Thanks!

Regards,
Rajat

 

[kate]

put the value in the list box in the INPUT PARAMETERS
property of the report
Forms]![frmReportClient]![lstReportClient]

I'm trying to do the same thing. It seems to find it when
you put the reference in the Input Parameters property but
I can't get that value to print on the report.
I have tried making a variable in the Open Report event
and saving it there, but it tells me it can't find it!
ARRRGGHH!
If you figure it out, please let me know!

 

[Rajat]

Kate,
I can't seem to find the InputParameters property in my
report's property sheet. I looked in the All tab too.
Where do you see it?
Regards,
Rajat

-----Original Message-----
put the value in the list box in the INPUT PARAMETERS
property of the report
Forms]![frmReportClient]![lstReportClient]

I'm trying to do the same thing. It seems to find it when
you put the reference in the Input Parameters property but
I can't get that value to print on the report.
I have tried making a variable in the Open Report event
and saving it there, but it tells me it can't find it!
ARRRGGHH!
If you figure it out, please let me know!

-----Original Message-----

Hi,

I have a report with recordsrc qry4.

qry4 calls qry3 which calls qry2 which finally calls qry1.

qry1 has a parameter called [Report Client], and I am
prompted for its value and everything works fine.

Now I would like to run the report from a form, such that
the report takes the parameter from the current selection
on a lstbox on the form.

The criteria in qry1 is:
[Report Client] or "any"

I tried making it:

[Forms]![frmReportClient]![lstReportClient] or "any"

but instead of just taking the value from the form, it
again prompts the user for it.

I even renamed the parameter to:
[Forms]![frmReportClient]![lstReportClient]

but with no luck!

Any ideas?

Thanks!

Regards,
Rajat


.

.

 

[Andy Cole]

Rajat

Is your listbox's Multiselect property set to None? It will need to be to
use the default .Value property implied in your query parameter,
Forms]![frmReportClient]![lstReportClient]

HTH

Andy

Kate,
I can't seem to find the InputParameters property in my
report's property sheet. I looked in the All tab too.
Where do you see it?
Regards,
Rajat

-----Original Message-----
put the value in the list box in the INPUT PARAMETERS
property of the report
Forms]![frmReportClient]![lstReportClient]

I'm trying to do the same thing. It seems to find it when
you put the reference in the Input Parameters property but
I can't get that value to print on the report.
I have tried making a variable in the Open Report event
and saving it there, but it tells me it can't find it!
ARRRGGHH!
If you figure it out, please let me know!

-----Original Message-----

Hi,

I have a report with recordsrc qry4.

qry4 calls qry3 which calls qry2 which finally calls qry1.

qry1 has a parameter called [Report Client], and I am
prompted for its value and everything works fine.

Now I would like to run the report from a form, such that
the report takes the parameter from the current selection
on a lstbox on the form.

The criteria in qry1 is:
[Report Client] or "any"

I tried making it:

[Forms]![frmReportClient]![lstReportClient] or "any"

but instead of just taking the value from the form, it
again prompts the user for it.

I even renamed the parameter to:
[Forms]![frmReportClient]![lstReportClient]

but with no luck!

Any ideas?

Thanks!

Regards,
Rajat


.

.

 

[Rajat]

Andy,
It is set to None.
Rajat

-----Original Message-----
Rajat

Is your listbox's Multiselect property set to None? It will need to be to
use the default .Value property implied in your query parameter,
Forms]![frmReportClient]![lstReportClient]

HTH

Andy

Kate,
I can't seem to find the InputParameters property in my
report's property sheet. I looked in the All tab too.
Where do you see it?
Regards,
Rajat

-----Original Message-----
put the value in the list box in the INPUT PARAMETERS
property of the report
Forms]![frmReportClient]![lstReportClient]

I'm trying to do the same thing. It seems to find it when
you put the reference in the Input Parameters property but
I can't get that value to print on the report.
I have tried making a variable in the Open Report event
and saving it there, but it tells me it can't find it!
ARRRGGHH!
If you figure it out, please let me know!

-----Original Message-----

Hi,

I have a report with recordsrc qry4.

qry4 calls qry3 which calls qry2 which finally calls qry1.

qry1 has a parameter called [Report Client], and I am
prompted for its value and everything works fine.

Now I would like to run the report from a form, such that
the report takes the parameter from the current selection
on a lstbox on the form.

The criteria in qry1 is:
[Report Client] or "any"

I tried making it:

[Forms]![frmReportClient]![lstReportClient] or "any"

but instead of just taking the value from the form, it
again prompts the user for it.

I even renamed the parameter to:
[Forms]![frmReportClient]![lstReportClient]

but with no luck!

Any ideas?

Thanks!

Regards,
Rajat


.

.

.