Copying Partial Record in Form

[lansel]

I have been reviewing all the threads concerning this subject and I got really confused because I don't understand all the code. I am trying to copy only part of a record on a form; three fields actually:

Entry Date
Site
Operator name

The site and operator name fields are cascading combo boxes. I inserted a command button for a duplicate record and I used some code I found on the forum, but I probably didn't use it correctly.

Private Sub Command56_Click()

Dim v1 As Variant
Dim v2 As Variant
Dim v3 As Variant

v1 = Me!EntryDate.Value
v2 = Me!Site.Value
v3 = Me!OperatorName.Value

RunCommand acCmdRecordsGoToNew

Me!Field1 = v1
Me!Field2 = v2
Me!Field3 = v3
End Sub

Anyway, I did something wrong and it is not working. I would appreciate some help with this.

Thanks!

 

[lansel]

Oops I made a mistake on the third part. I actually had the following:

v1 = Me!DataEntry.Value
v2 = Me!Site.Value
v3 = Me!OperatorName.Value

Sorry!