How to invisible some records of my form for other users

[masoud_sedighy]

I have a database that it has 2 forms.
Form 1 shows list of received letters
Form 2 shows list of send letters
Now database has been splitted and back end is on the shared drive and front end there is on each computer and myself and other users have read/write access to the shared drive and me and other users can see all the records. .Now I would like to add something like a check box field to the forms. When I tick the check box for each record other users cannot see that record on the form.​

Please help how I have to do that.

 

[Mile-O]

First, have a Yes/No field in the table that's bound to the form.
Secondly, use a bit of code in the form's OnCurrent event to check that field.