thanks for your help with this, i have the spry tabs effect in place now along with the recordsets and a repeating table in the content area of the tabs which shows if recordset is not empty.
this works fine however the tabs themselves i have as blue but i want it to be red if the recordset is empty how could i change this?
also eric i have created a page where the user can add a company name with product desciption which inserts fine into database.
how can i get it to take the product description and add into into a new tab automatically with a recordset creating from it along with an insert form?
i know the second one might be alot of hand coding so if it is tricky i might just change that page to a drop down menu and bind the menu to the product description column of that table but thought i would ask you anyway :)