I have the following code in the OnClick event of my command button:

Private Sub cmdEditProject_Click()
On Error GoTo Err_cmdEditProject_Click
DoCmd.OpenForm "frmEditProjects", , , "[tblNewProjects]![Proj_ID] = " & Me![Proj_ID]
Exit_cmdEditProject_Click:
Exit Sub

Err_cmdEditProject_Click:
MsgBox Err.Description
Resume Exit_cmdEditProject_Click
End Sub

Can I add a second filter after Proj_ID to filter for Work_ID as weell? What would be the proper syntax (an AND statement)?

DoCmd.OpenForm "frmEditProjects", , , "[tblNewProjects]![Proj_ID] = " & Me![Proj_ID] AND [tblNewProjects]![Work_ID] = " & Me![Work_ID]

Edited because I didn't use Work_ID in my example.

YEP! AND is fine....also could say things like AND [tblProjects]![completiondate]>date()



[This message has been edited by jwindon (edited 11-29-2001).]

Thanks jwindon. You always have an answer.

DoCmd.OpenForm "frmEditProjects", , , "[tblNewProjects]![Proj_ID] = " & Me![Proj_ID] AND "[tblNewProjects]![Work_ID] = " & Me![Work_ID]

Think I left out a ".
Sorry.

One more time for good measure http://www.access-programmers.co.uk/ubb/smile.gif

DoCmd.OpenForm "frmEditProjects", , , "[tblNewProjects]![Proj_ID] = " & Me![Proj_ID] & " AND [tblNewProjects]![Work_ID] = " & Me![Work_ID]