issue with Form parameters

  • Thread starter Thread starter Manjula
  • Start date Start date
M

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
 
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
 
Back
Top