Thread: stLinkCriteria Syntax
View Single Post
  #2  
Old May 4th, 2010, 04:32 PM posted to microsoft.public.access.forms
Douglas J. Steele[_3_]
external usenet poster
  
Posts: 3,143
Default stLinkCriteria Syntax
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 & "' & "'"