"OR" Filter

[kjuelfs]

Hello,

I'm trying to build a string for the Filter property to be set in the VBasic Code.

The syntax which works when doing a manual "advanced" filter directly in the form is as follows: Like "NUMBER1*" Or Like "NUMBER2*"

I need all entries with the one number or the other. In the code I want to do the same for 1 to n different numbers.



What does the syntax look like? I've tried these:

Me.Filter = ([FIELD] Like "NUMBER1*") OR ([FIELD] Like "NUMBER2*")
Me.Filter = ([FIELD] Like "NUMBER1*" OR [FIELD] Like "NUMBER2*")
Me.Filter = ([FIELD] Like "NUMBER1*" OR Like "NUMBER2*")
Me.Filter = [FIELD] Like "NUMBER1*" OR Like "NUMBER2*"

I also want to add the condition... AND [OTHER_FIELD] = "TYPE"... what would this look like in combination with the OR filter string?

Thanks in advance

[jzwp11]

Is the field you designate as [FIELD] a number or text datatype? I assume it is text since you are using the LIKE operator.

I would think something like this would work (air code, not tested):

dim myFilter as string

for i=1 to n
myFilter = myFilter & "([FIELD] Like 'NUMBER" & i & "'*) OR "
next i

'now strip off the last OR and the following space (ie 3 characters)

myFilter= left(myFilter, len(myFilter)-3)

myFilter=myFilter & " AND [OTHER_FIELD] = 'TYPE'"
me.filter=myFilter

[kjuelfs]

Thanks, that worked. I was just missing the ' marks.

[jzwp11]

Glad to here you came to a solution. Best of luck on your project.