Slow response on Form in Access with queries converted SQL views (1 Viewer)

If I just execute the SP it will not give a result because it needs the parameter
Here is the error

Msg 201, Level 16, State 4, Procedure Find_Product, Line 0
Procedure or function 'Find_Product' expects parameter '@searchstring', which was not supplied.

If I plug in a value like 11 it returns plenty of records
So I believe it is working as designed
So I need to do something different on the Access Form side right?
RRII

SQL_Hell said:

Ok well that stored proc should work fine so no problems there, I would have done the stored proc in a different way but the end result would be the same.

does it still only return 1 row in SSMS?

Click to expand...

Still fighting with this
I know the Stored Procedure is working correctly Did some additional testing over the weekend and I know it it returning the right results
Do I need a different setup in the VB code to get the multiply entries out?
The code only provides a single result at the moment
Thanks Again
RRII