I am trying to open a form that has to meet two criterias. One is simple and the other is a bunch of or statements. Here is the code that I thought should work but I keep on getting an error. Is it a syntax problem?

stLinkCriteria = "([Mill 1] = '" & txtMill.Value & "' Or [Mill 2] = '" & txtMill.Value & "' Or [Mill 3] = '" & txtMill.Value & "' Or [Mill 4] = '" & txtMill.Value & "' Or [Mill 5] = '" & txtMill.Value & "' Or [Mill 6] = '" & txtMill.Value & "' Or [Mill 7] = '" & txtMill.Value & "' Or [Mill 8] = '" & txtMill.Value & "' Or [Mill 9] = '" & txtMill.Value & "' Or [Mill 10] = '" & txtMill.Value & "') And ([Stage] = '" & StageHidden & "')"

Please help!
andy

Figured it out myself....

stLinkCriteria = "([Stage] = '" & StageHidden & "' And [Mill 1] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 2] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 3] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 4] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 5] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 6] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 7] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 8] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 9] = '" & txtMill.Value & "') Or ([Stage] = '" & StageHidden & "' And [Mill 10] = '" & txtMill.Value & "')"