filter form data based on combo box value

  • Thread starter Thread starter Sylvain
  • Start date Start date
S

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