I am new to Access 2007 and new to VB programing. I am wanting to be able to click on a button to start a new record and copy selected fields to that new record without having to re-enter information. I know how to create the button and enter the code. Here is some code that I found on the net but I can't get it to work. Any ideas? Is their an easier way to do this?

Private Sub Command39_Click()
Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant
Dim v4 As Variant
Dim v5 As Variant


v1 = Me!Username.Value
v2 = Me!Department.Value
v3 = Me!Supervisor.Value
v4 = Me!dateissued.Value
v5 = Me!issuedby.Value
RunCommand acCmdRecordsGoToNew

Me!Username = v1
Me!Department = v2
Me!Supervisor = v3
Me!dateissued = v4
Me!issuedby = v5


End Sub