the question was a simple one.
in your recordsets, you are using the LEDprodvarname to compare the Option Group name
WHERE LEDprodvars.LEDprodvarname = 'Colour'
WHERE LEDprodvars.LEDprodvarname = 'Sensor'
how, then, can you expect that column to also contain the option name?
my apologies for poor wording.
I dont think it is unfair to think you have been able to see the connection that your recordsets where clause for the option category was using the same column you where trying to use for the option name.