He does this in the Check Register Seminar. He as it so if the check has cleared the bank, it is locked and can't be changed.

I forgot to say, he uses an IsCleared checkbox for the transaction to lock the field.

One way is to use the Current event to set the form's AllowEdits and AllowDeletions properties to the criteria you need.  The criteria need to be record-specific, of course, and doesn't need to be from a checkbox.  You can set the criteria so that records from a certain date range can't be edited, for instance.  Even though AllowEdits and AllowDeletions affect the whole form, you can make them affect only the records that satisfy the criteria with the Current event.

Thank you Sandra and Kevin

I will check the check register seminar

Hey Sami, Is that two questions? How to lock all the records and/or maybe just one? When you say "lock", what exactly do you mean?

Hi Thomas
Just one question. @Sandrah example is a good one. A continued form containing Check Book information. You check a box IsCleared. Now you want to prevent the user from changing 'lock' that record.

Hi Sandrah

I watch the Check register videos where Richard creates the form. unfortunately I did not see him locking the record that has been "IsCleared". i wonder if the boss will chime in on this thread.

HI Kevin.
can you please elaborate on what you said? how can I effectively only disable AllowEdits and AllowDeletions for only a record that meets a criterion and not have that affect the entire record set in the continuous form?

The user can only edit one record at a time, not all records simultaneously.  So it doesn't matter if the whole form is disabled or enabled.  The user can only put the cursor on one record at any time.  Wherever the cursor is put, the Current event for that record is run.  So as long as the Current event sets the right criteria, the user can only edit records that are allowed to be edited by the criteria.

This only affects user activities on the form, of course.  It has no effect on action queries from VBA that affect the form's data, for instance.

Thank you Kevin. I will try it this weekend.

AfterUpdate event for the IsCleared box makes that record locked (lock the individual controls, or set AllowEdits to NO). OnCurrent event checks that field when you move from record to record. You'll have to also disable AllowDeletions, which I normally do anyways so I can control those with my own button. Don't I cover all of this in Disallow Editing Data?

Thanks Richard.

I will check the  Disallow Editing Data? this weekend.

Sami, did you watch the Check Register Seminar or free Tech Help video. This is from the handbook.

Let's check it. That's been printed. I shouldn't be able to change it. Yep, everything's locked. However, the
deposit hasn't cleared, and I can change the information on it.

Hi Sandra
I was watching the actual seminar; however, I may have not watched long enough to the check printing part. I will do that next.
Many thanks