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