Filter with multiple criteria 1

[Moss100]

Hello,

Please can someone help.

I need to filter a form so records display when the field [Prop_Link] equals any of either 10,15,20 or 24

My code runs fine for one value, but how do I combine the other values

me.form.filter = "[Prop_link] = 24"

Many thanks Mark

 

[Andrzejek]

Did you try:

me.form.filter = "[Prop_link] = 10 or [Prop_link] = 15 or [Prop_link] = 20 or [Prop_link] = 24"

---- Andy

There is a great need for a sarcasm font.

 

[Moss100]

Thank you my friend )

 

[Andrzejek]

You may also try:

me.form.filter = "[Prop_link] [blue]IN[/blue] (10, 15, 20, 24)"

Worth a shot...


---- Andy

There is a great need for a sarcasm font.