if statement

[Dan]

I am having the weirdest problem. This is the code that I have:

If myGender = 2 Then
stLinkCriteria = "[gender] = 1 AND [Status] IN ('Active', 'Ar - In
Matching') AND [member number] NOT IN (SELECT [matchesmembernumber] FROM
Matches WHERE [MemberNumber] = " & Me.Member_Number1 & ")"

Else: 'stLinkCriteria = "[Status] IN ('Active', 'Ar - In Matching') AND
[member number] NOT IN (SELECT [matchesmembernumber] FROM Matches WHERE
[MemberNumber] = " & Me.Member_Number1 & ")"
stLinkCriteria = "[gender] = 2 AND [Status] IN ('Active', 'Ar - In
Matching') AND [member number] NOT IN (SELECT [matchesmembernumber] FROM
Matches WHERE [MemberNumber] = " & Me.Member_Number1 & ")"
End If

It works for the if statement but it doesn't work for the else. It gives me
an error: #2501 THe open form was canceled. I have tried everything. ANy
suggestions?

 

[Dan]

I almost forgot I am just calling this statement:

DoCmd.OpenForm stDocName, , , stLinkCriteria

 

[Graham R Seach]

Dan,

The problem will most likely be in the form's Open event somewhere, because
you could have the following and the form will still open:
DoCmd.OpenForm stDocName, , , "Blah = 'Blah'"

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html