The line continuation characters cannot be inside the quotes.
stLinkCriteria = "[FiscalYearInd] = '" & Me.lstFiscalYear & "' " & _
"And [UHC_DEPT_NUM] = '" & Me.Text217 & "' " & _
"And [PROV_UHC_CAT_NUM] = '" & Me.Text219 & "' " & _
"And [DivisionCode] = '" & Me.Text221 & "'"
--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)
"Brian J" wrote in message
...
I am unable to get my syntax working for my four criteria. Can anyone
suggest what is wrong?
stLinkCriteria = "[FiscalYearInd] = '" & Me.lstFiscalYear & "' _
And [UHC_DEPT_NUM] = '" & Me.Text217 & "' _
And [PROV_UHC_CAT_NUM] = '" & Me.Text219 & "' _
And [DivisionCode] = '" & Me.Text221 & "' & "'"