OpenForm WhereCondition 'Or' Syntax

[iamstuart]

Hi,
I am using access 2003 and have some code that opens a form and filters it using the werecondition, the code works apart from the "Measure" i need it to filter it for any of the 3 options 'loft' Or 'boards' Or 'Loft & Boards' which filters fine when manually entered into the filter but am having problems finding the correct syntax for it to put this in automatically, the code i have currently which all works other than the "Measure =" is:

Dim stDocName As String
  
stDocName = "Main Table"
DoCmd.OpenForm stDocName, acNormal, , "[Postalcode] Like '" & PostalAreatxt & "*' and Measure= & 'loft' & " Or " & 'boards' & " Or " & 'Loft & Boards' and [Cancel Contract?] =False and IsNull([Completion Date]) and IsNull([Fit Scheduled Date1]) and IsNull([Fitters Names1])"

[TheSmileyCoder]

Welcome to Bytes

That is because each OR condition must contain its own True/false evaluation.
Example of Bad:
X=1 or 2 or 3
Example of Good:
X=1 or X=2 or X=3

Using the _ will allow you to break up those long code lines to several lines to increase readability and maintain overview
You also do not need & between single quotes '
I have also added a set of parenthesis around your Or statements, as I presume they are meant as a group.

DoCmd.OpenForm stDocName, acNormal, , _
    "[Postalcode] Like '" & PostalAreatxt & "*' and (" & _
    "Measure= 'loft' Or " & _
    "Measure= 'boards' Or " & _
    "Measure= 'Loft & Boards') and " & _
    "[Cancel Contract?] =False and " & _
    "IsNull([Completion Date]) and " & _
    "IsNull([Fit Scheduled Date1]) and " & _
    "IsNull([Fitters Names1])"

Finally to add some extra confusion you could also do:

Measure In ('loft','boards','Loft & Boards)

(You might have to replace , with ; based on regional settings)

[iamstuart]

This worked perfectly, thanks so much this had been frustrating me for days!

[NeoPa]

As close to a perfect answer as you're likely to find anywhere.

Nice one Smiley :)