I have around 15 - 20 automatically populated fields in
'Defects_Bug_New', when I manually change the value of one field from the default, the next time I click the add fect button it doesn't populate with the default value below but contains the value I used from the list last.

I can not find anthing that should over write, my "Defects_Bug_New", but that seems to be what is happening

Sub Defects_Bug_New

Bug_Fields("BG_USER_12").Value= "Defect"
....... other fields 1-20. etc.....
End Sub