Dounble filters for forms

C

Chris Freeman

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
 
G

Gary Miller

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'"
 
Top