Form doesn't work as a subform

[SeaRox]

Probably an easy fix for someone with a little more experience.
I have a continuous form that I designed as a subform. I have a "copy record" button at the bottom. When I open the form by it's self the button works perfectly. When I open the main form and click the copy button in the sub form it just creates a blank new record. The code for the button is this:

Private Sub Command32_Click()
On Error GoTo Err_Command32_Click

    DoCmd.RunCommand acCmdSaveRecord
    DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70
    DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70 'Paste Append
    Me.Requery

Exit_Command32_Click:
    Exit Sub

Err_Command32_Click:
    MsgBox Err.Description
    Resume Exit_Command32_Click
    
End Sub

Any ideas how to make it work as a subform?

 

[ajetrumpet]

this code:

Me.Requery

...could possibly be the problem. You probably need the correct subform reference code for the button, because it is nested inside the mainform when you are getting the blank record.

Have you seen Bob Larson's FAQ page on the subform reference issue?

http://www.access-programmers.co.uk/forums/showthread.php?t=127981

 

[SeaRox]

I tried taking the Me.Requery out. It still did the same thing.

The link by Bob Larson that was suggested is a good one to bookmark. I tried several different combinations of the references but either I'm doing it wrong or they dont work for DoCmd.

Since it wasn't the Me.Requery that was the problem, does anyone have any other ideas?