Proper way to sort/filter

[ssb]

I'm using access to track a document through a multi step review process. My
table has a yes/no for when all reviews are completed. I've created a form
based on my table for users to easily check the review status of a paticular
document and also make updates as necessary. Now I realize that once the
final yes has been toggled for all reviews complete I don't want to see it
anymore as a record in the form. Can I sort or filter out those records or
should I have based my form on a query? Thanks - Newbie

 

[strive4peace]

you can set a form filter

me.filter = "fieldname <> True"
me.filterOn = true
me.requery

you can also save the filter in the form properties -- make
sure to set FilterOn = true


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*