Posted on 2004-09-14
I am trying to open a form using two criteria. It works fine with either one, but I am getting a "type mismatch" when I combine the two. I think I am just combining them wrong. Please help.
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "product_a"
stLinkCriteria = "[Step3]=" & Me![No] And "[Step2]=" & Me![Yes]
DoCmd.OpenForm stDocName, , , stLinkCriteria