S
Scamps
Hello.
I have a form with a subform. in the subform (based on a SQL stored
procedure) I use two paramters to show the filtered data I want.
= @Parameter1
and
Like @Parameter2
the two parameters are linked via the inputparameters section of the form to
two textboxes txtbox1 and txtbox2(on the parent form). I let the users select
the variables to enter into these txtboxes (setting the controlsource
programmatically).
In @Parameter2 I want to be able to pass a wildcard so that all records are
shown. I think this should be a control with ='%' as the controlsource. It
doesnt work, showing only records related only to one of the variables. the
paramter works otherwise, because if I pass (for example) ='d' to the
parameter than it shows only the varable 'd' results. If I revert back to
='%' it again only shows one of the desired resultant record groups.
Yet, if I type in the criteria "Like '%'" in to the actual SQL stored
provedure the results are as expected with all the parameter variables being
shown in the resultant recordset.
Can anyone help me get the right sintax passed through the parameter to act
as a wild card. ?
Thanks in advance
Scamps
I have a form with a subform. in the subform (based on a SQL stored
procedure) I use two paramters to show the filtered data I want.
= @Parameter1
and
Like @Parameter2
the two parameters are linked via the inputparameters section of the form to
two textboxes txtbox1 and txtbox2(on the parent form). I let the users select
the variables to enter into these txtboxes (setting the controlsource
programmatically).
In @Parameter2 I want to be able to pass a wildcard so that all records are
shown. I think this should be a control with ='%' as the controlsource. It
doesnt work, showing only records related only to one of the variables. the
paramter works otherwise, because if I pass (for example) ='d' to the
parameter than it shows only the varable 'd' results. If I revert back to
='%' it again only shows one of the desired resultant record groups.
Yet, if I type in the criteria "Like '%'" in to the actual SQL stored
provedure the results are as expected with all the parameter variables being
shown in the resultant recordset.
Can anyone help me get the right sintax passed through the parameter to act
as a wild card. ?
Thanks in advance
Scamps