stLinkCriteria syntax problem 1

[glxman]

Hi I am simply trying to open a form with the following but I have tried all sorts and cannot get the syntax right.

stLinkCriteria = [Exclude] <> 0


The Exclude is a yes/no as a tick box and all I want it to do is show all records with a tick - I would get round it by entering the criteria in the underlying query but I would then have to replicate as I have a lot of other fields that I want to link criteria in the same manner - I cannot link it directly to controls as the form is not setup that way.

Many thanks

 

[PHV]

Perhaps this ?
stLinkCriteria = "[Exclude] = True"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[glxman]

knew it was simple, thanks!