issue with Form parameters

[Manjula]

I have a form where user can select FY and Quarter and I would like to pass
user selection as parameters to the stored Procedure. And I want to use this
stored procedures as source for a report. Could any one get this working in
adp?

In access 2007, i would just use query instead of sp with parameters as
Form!frmwhatever etc both in report and query.

Any help would be greatly appreciated

 

[Bob McClellan]

Manjula,
You can do this easily. If you are running the report by clicking a button
on the
form, simply drive the parameter to a textbox on the form, then reference
that textbox.

So, if your SP is something like....

create proc ShowMyData
@MyParam
as
select *
from mytable
where myColumn = @MyParam

Then, on the form...
if they pick the criteria from a combo box,
drop the result to the textbox.

ON THE REPORT...
RecordSource = dbo.ShowMyData
Input Parameters = @MyParam = FORMS![MyForm].form.MyTextBox.

hth,
...bob