Hi Imar - No errors - I have tested it numerous times - and have checked the database - nu duplicate records are being added and every new record is being added! I know the code is ugly - but I am getting really used to using dreamweaver (I just switched to DM MX2004).

I do have another question though :>)

I want to be able to insert multiple records based on one field that can be selected multiple times. Basically - I have the tbl where freezer=x Tower=X Box=X and location is the field that will be selected multiple times. I guess what I need is to be able to run a loop of some sort - I have looked around - but haven't found anything very helpful.