I don't understand, you want to take records from one table between two dates and append them to another table?
I would have the user select the dates on your form, then in the query criteria put this line:
BETWEEN Forms!Archive.StartDate AND Forms!Archive.FinishDate
Then just do a DoCmd.OpenReport, or DoCmd.RunQuery (which would run your Append Query above and pull the dates off your form without passing them in code. No need for all this code.