using a stored procedure as recordsource with "dynamic" inputparams 3

[pharcyder]

Hi,

I've got a report using a Stored Procedure as Recordsource.
The Stored Procedure can have parameters, i.e.
sp_test '01' shows all records where the userid = '01'

There ist the possibility to set these InputParameters in the Properties of the Report, but how can I use a textfield or a variable for these InputParameters ?

I can't change the InputParameters while the Report is in acViewPreview.

Is there perhaps another trick I can use to pass parameters to the sp ?

Thanks in advance,
Jens

 

[pharcyder]

Okay, problem solved...

you can type:
@userid = [Forms]![frm_Test]![txt_userid]
in the InputParameters-property and the stored procedure takes the value from this field....

Greetings from Germany,
Jens

 

[blackte]

pharcyder, where is the InputParameters - Properties Box. I have a store procedure on an SQL Server that has input variables, and I would like to send variables to it from form inputs, but can not see where to do this. Can you help. Thanks in advance for the help with this.

Thanks Travis.

 

[cmmrfrds]

Go to the data tab in the Form and the last property is input parameters. enter in the format of:

@parm1=myvariable,@parm2=myothervariable

or
@parm1=Forms!formname!me.myvariable,@parm2=Forms!formname!me.myothervariable,

 

[blackte]

cmmrfrds, is this something that is in access 2000? I do not see it within access 97. Thanks again. Thanks Travis.

 

[cmmrfrds]

Sorry, but I believe that is the case.