filter form data based on combo box value

[Sylvain]

I'm trying to filter the data of a form based on the value
of a combo box. The form record source is a stored
procedure. I have entered input parameter in the stored
procedure and in the form like this:
stored procedure:
@issuer nvarchar = [form]![cmbname]
Form property sheet:
issuer nvarchar = [forms]![NCR_List]![cmbname]

The form opens but never show any data. How should I do it?

And what about the default value in the stored procedure,
do I need to put one?

Thanks
Sylvain

 

[Vadim Rapp]

S> I'm trying to filter the data of a form based on
S> the value of a combo box. The form record source is
S> a stored procedure. I have entered input parameter
S> in the stored procedure and in the form like this:
S> stored procedure:
S> @issuer nvarchar = [form]![cmbname]

The stored procedure is unaware of your Access forms. It should be

create procedure pp (@parm1 varchar(50) ) as .....

Then in Access, specify InputParameters of the form as

@parm1 = forms!Form1!Combo1


Vadim

 

[Sylvain]

Thanks you put me on the right track. It works now.