that's a problem with the recordset query.
your where claus:
WHERE name_tb LIKE '%tiger nut'
is looking for the string "tiger nut" at the end of the name it will only return a result if the the name ends with "tiger nut". your not getting any results because you don't have any products whose name ends with "tiger nut"
if I change that to:
WHERE name_tb LIKE '%tiger nut%'
it is looking for the string "tiger nut" anywhere in the name, and returns a result.
be careful with the wild card characters when doing a like query. depending on how you use the wild card, you create a 'Begins With', 'Ends With', Or 'Contains' condition:
Begins with 'foo'
SELECT * FROM tableName WHERE columnName LIKE 'foo%'
Contains 'foo'
SELECT * FROM tableName WHERE columnName LIKE %foo%'
Ends with 'foo'
SELECT * FROM tableName WHERE columnName LIKE '%foo'
