Comments by Aaron Tearle (Top 1 by date)

Adding to stored procedure line certainly helped!
I however still can't get the form to behave as the stored procedure does. The is issue I am having is with partial string matches. I have the wildcards in the store procedure and this works fine - it returns the records I would expect to see. In the form however it doesn't. In the form, if I feed in an exact match for a string in one of the fields I am searching, then the correct record is returned, if I input a partial match, nothing is returned. I have tried moving the wildcard from the stored procedure to the form parameter, but this doesn't seem to make any difference.