Onload Filter Question

[alexandervj]

I'm still a noob with VBA. Heres my onLoad filter, its not working.. I'm sure its just syntax. just with Me.Filter = "[Deleted] = False" it works fine, not sure how to add "or"s

Private Sub Form_Load()
Me.Filter = "[Deleted] = False Or [GeographicalLocation] = 'Abq Trash/Reject' Or [GeographicalLocation] = 'Reject/Trash'"
Me.FilterOn = True


End Sub

[pbaldy]

Looks okay offhand. Are you sure the location values aren't an ID rather than the text?

[alexandervj]

Yeah I checked in the database and the value stored in the fields is the text, not the ID. I dont get it. I did realize I needed to change the code to

Private Sub Form_Load()
Me.Filter = "[Deleted] = False Or [GeographicalLocation] <> 'Reject/Trash'"
Me.FilterOn = True
End Sub

Cause I'm trying to filter out all deleted parts and parts in the trash location, and it filters out deleted parts fine, but not the ones in the trash

[pbaldy]

Oh, change Or to And.

[alexandervj]

Wow, you're right it worked.. seems weird to say And though, seems like that would filter out parts that were both deleted and in the trash location instead of either deleted or in the trash... very strange VBA stuff... but it worked! thanks!

[pbaldy]

Happy to help! When you use <> instead of = it flips the logic.

[alexandervj]

Aahh I see! Thanks again!