Dounble filters for forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to do a double filter on opening a form:
stLinkCriteria = "[SchoolMAX Design Module]=" & "'" & Me![SchoolMAX Design
Module] & "'" And [Origination] = "LINC Reports"

The second half of the statement causes error message: Can't find field "|"
reffered to in your expression.

Anyone have any suggestions?

Thanks in advance
 
Chris,

I may simply be that you are using double quotes around LINC
Reports. The last double quote is ending the string after
[Origination] = .Try...

stLinkCriteria = "[SchoolMAX Design Module]=" & "'" &
Me![SchoolMAX Design
Module] & "'" And [Origination] = 'LINC Reports'"
 
Back
Top