Lock data entry in Form

[Guest]

I have a combo box - Status- with active-closed. when set to "closed" i want
to lock the data entry for this record.

 

[Guest]

In the combobox's AfterUpdate event, put:

Me.AllowEdits=(Me.Status = "Active")
Me.AllowAdditions=Me.AllowEdits
Me.AllowDeletions=Me.AllowEdit

Barry

 

[Guest]

Hi Barry,
Thanks for your help, it works - but when I reopen the data base the record
set to "close" can be edit again. Any further thoughts?
jorg

 

[Guest]

When you say the record can be edited again, do you mean through the form or
are you trying to edit it in the table?

This code doesn't affect the ability to edit the record, it just changes
properties on the form when the record is displayed. The code basically says,
if the status column on the current record is "active", allow edits,
otherwise don't.

Barry

 

[Guest]

When you say the record can be edited again, do you mean through the form or
are you trying to edit it in the table?

This code doesn't affect the ability to edit the record, it just changes
properties on the form when the record is displayed. The code basically says,
if the status column on the current record is "active", allow edits,
otherwise don't.

Barry

 

[Guest]

Through the form. also once "closed†is applied all other records are also
not edible.

 

[Guest]

Ok. You should put this code in the form's OnCurrent event as well.

Barry

 

[Guest]

Thanks Barry, that was it.

Ok. You should put this code in the form's OnCurrent event as well.

Barry