var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Syntax query - boolean
I'm working on building a DLookup where one of my criteria is a boolean (yes no), but I'm not sure of the correct syntax. I've obviously got it wrong though since its failing on that point.
The syntax I've got for the third criteria point is
I've tried specifiying the criteria value as true or false and the code works, so it must be something in the line above I've got wrong.
& " AND [VolumeMeasuringCylinder] = & Forms!frmSet!subfrmVolume!VolumeMeasuringCylinder ")
VolumeMeasuringCylinder is stored (using the same name) in both tables as yes/no.
I've been searching for the correct syntax but other than finding a reference to treating it as a number I'm getting no where.
Any assistance would be greatly appreciated.
& " AND [VolumeMeasuringCylinder] = " & Forms!frmSet!subfrmVolume!VolumeMeasuringCylinder)
Have a nice day!
Ahaaa brilliant thanks Sinndho, that seems to have solved the issue. Very much appreciated.