Thank you for your reply.
Alas I just cant make it work.
I have sent screen captures of all the secondary tables and recordsets.
Frame-Colour table, Main recordset-rsPrintFrame, FrameColour-rs, Dynamic list for colour for the send to cart button, and a Cart ScreenShot.
Its got to be a "Doh" moment, I'm sure.