ok, table names are highlighted in red, field names in blue:
SELECT productoptions.OptionPriceincrement, productoptions.ProductOptionID, options.OptionName, options.OptionGroupID, optiongroups.OptionGroupName
FROM options
INNER JOIN productoptions ON options.OptionID = productoptions.OptionID
INNER JOIN optiongroups ON options.OptionGroupID = optiongroups.OptionGroupID
WHERE optiongroups.OptionGroupName = 'color' AND productoptions.ProductID = paramItem
the recordset will be empty if there are no options for the product in the product options recrodset so you would use a Show If behavior to only show the option select list if the recordset is not empty.