you would need to edit the product recordset to use a join query to get the category name from the category table that relates to the product.
i see you have a column in your products table named CategoryID, so an example of the query would be:
SELECT products.*, categories.CategoryName
INNER JOIN categories
ON products.CategoryID = category.CategoryID
NOTE: Don't edit the where clause, leave the where clause as is
for more detail son join queries, see this page: