Hi, i've got the same problem but the solution wont do. Have you an another suggestion. I'm not use to VB and not so good in english to, sorry for that.
Here's my original string:
stLinkCriteria = "[Section]=" & "'" & Me![Section] & "'" And "[Site]=" & "'" & Me![SITE]
Cause a mistype error, tryed yours :
stLinkCriteria = "[Section]=" & Me![Section] & " And [site]=" & Me![SITE]
cause a Syntax error, (missing operator) in expression.
Originally Posted by pbaldy
You never restart the string after the first form reference. Try:
First thanks for the fast reply. This other method work with one criteria But it still won't work with multiple criteria. Has tgavin's problem, the first form is use only to choose what to show on the second one. witch is a form base on a cross analysis query. Why condition "and" wont work?
The link was simply to demonstrate that different data types require different delimiters, or none. Since you haven't said what the data types of your 2 fields are, it's hard to do say why yours isn't working.
It work!!!!! You are a machine! , but i don't understand.... a chance we have cut and paste option. Has i said i'm not use to VB, i've learn Access on my own and please when i can leran something. Have you a "Baldy" web seminar or another web link that simply explain the basic of VB language? Thank you a lot, you've make my day.