Synchronize records between two forms

[EVP]

Hi,

Can anyone help me with why this is not working?
In the event code of a command button I have:

Private Sub DocStatusCmd_Click() -THIS IS HIGHLIGHTED??
On Error GoTo Err_DocStatusCmd_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Documentation Status"
DoCmd.OpenForm "Documentation Status", , , "[MemberID]=" & Me.MemberID -AND THIS (.MemberID) IS HIGHLIGHTED??

Exit_DocStatusCmd_Click:
Exit Sub

Err_DocStatusCmd_Click:
MsgBox Err.Description
Resume Exit_DocStatusCmd_Click

End Sub

I get a compilation error, data not found.
Any help is appreciated, Thanks.

 

[Rich]

If MemberID is the field name then you should re-name the control to something else, try txtMembID and then Me.txtMembID

 

[EVP]

Thank you for the prompt reply.

Sorry for the newbie confusion,

But which is the control? My field name is MemberID.

Thanks again.