Multiple Where conditions in openform

[lxh]

Hi all

I need to open a form with both two necessary conditions, ie, the project number needs to be a cetain value and the bank number needs to be a certain value. Is is possible to do something like:

DoCmd.OpenForm FormFocus, acNormal, , (("TeamMemberID=" & frmCallingForm.TeammemberID) And ("ProjectDetailsID=" & frmCallingForm.ProjectDetailsID)), acFormEdit, acWindowNormal

thanks in advance
Lex

 

[lxh]

The openform line should read...

Hey There - I worked out what i was after - thanks for looking

the above line should have read:

DoCmd.OpenForm FormFocus, acNormal, , "TeamMemberID=" & frmCallingForm.TeammemberID & "AND ProjectDetailsID = " & frmCallingForm.ProjectDetailsID, acFormEdit, acWindowNormal

Thanks
Lex