Property Setting Long

[Evagrius]

Hi,

I am getting error "Property setting too long". I have around 200 criteria in the sample below? Is there a better way to do this? Thank you!!

Me.Filter = "[Number] IN ('12345','552364', . . . .  .

 

[boblarson]

200 criteria?

If so, create a table with one field for them and then instead of the filter you would change the form's recordsource to the query with that as the limiting factor.

You would do something like this in the query but instead of Is Null you would use Is Not Null.

 

[Evagrius]

Bob - thank you! I will work on this tonight and let you know how it works! Thank you!