Still doesn't work :0(
I'm now getting the error "Run-time error '3420' Object invalid or no longer set" . It's inserting the dates fine, eg. when I enter 01/01/07 to 10/01/07 it's inserting the first 2 dates as 01/01/2007 and 02/01/2007 but stopping at the rst value.

This time when I get the error and choose debug it takes me to the lin
Set rst = db.OpenRecordset(strSQL, dbOpenDynaset)