filtering main form...

[marduk813]

I would like to be able to filter my main form upon opening. The table for this form contains a Yes/No field called "Deleted". I have set the Filter property of my form to:

Tables![Case Data]!Deleted = No

but it still displays all records (even though I have marked 6 as deleted). I will actually need to do this on many of my forms, so as soon as I can get one to work, I can make the others follow suit.

Any suggestions?

 

[marduk813]

Oy. Nevermind, I fixed it. I don't know why I couldn't get the Filter property of the form to work correctly, but I just set up a filter in the VB code like:

Me.Filter = "Deleted = No"
Me.FilterOn = True

This did exactly what I needed. Thanks me! (and thanks to anyone who was going to reply!)