Lock data entry in Form

#1 (**permalink**) 28-Jul-2006, 08:35 AM

I have a combo box - Status- with active-closed. when set to "closed" i want
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13309-lock-data-entry-in-form.html
to lock the data entry for this record.

*

#2 (**permalink**) 28-Jul-2006, 08:35 AM

In the combobox's AfterUpdate event, put:

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

Barry

"Jorg" wrote:

> I have a combo box - Status- with active-closed. when set to "closed" i want
> to lock the data entry for this record.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309

#3 (**permalink**) 28-Jul-2006, 08:36 AM

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

"Barry Gilbert" wrote:

> In the combobox's AfterUpdate event, put:
>
> Me.AllowEdits=(Me.Status = "Active")
> Me.AllowAdditions=Me.AllowEdits
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> Me.AllowDeletions=Me.AllowEdit
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
>
> Barry
>
> "Jorg" wrote:
>
> > I have a combo box - Status- with active-closed. when set to "closed" i want
> > to lock the data entry for this record.

#4 (**permalink**) 28-Jul-2006, 08:36 AM

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

"Jorg" wrote:

> 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
>
> "Barry Gilbert" wrote:
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> > In the combobox's AfterUpdate event, put:
> >
> > Me.AllowEdits=(Me.Status = "Active")
> > Me.AllowAdditions=Me.AllowEdits
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> > Me.AllowDeletions=Me.AllowEdit
> >
> > Barry
> >
> > "Jorg" wrote:
> >
> > > I have a combo box - Status- with active-closed. when set to "closed" i want
> > > to lock the data entry for this record.

#5 (**permalink**) 28-Jul-2006, 08:36 AM

When you say the record can be edited again, do you mean through the form or
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
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

"Jorg" wrote:

> 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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> jorg
>
> "Barry Gilbert" wrote:
>
> > In the combobox's AfterUpdate event, put:
> >
> > Me.AllowEdits=(Me.Status = "Active")
> > Me.AllowAdditions=Me.AllowEdits
> > Me.AllowDeletions=Me.AllowEdit
> >
> > Barry
> >
> > "Jorg" wrote:
> >
> > > I have a combo box - Status- with active-closed. when set to "closed" i want
> > > to lock the data entry for this record.

#6 (**permalink**) 28-Jul-2006, 08:36 AM

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

"Barry Gilbert" wrote:

> 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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
>
> 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,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> if the status column on the current record is "active", allow edits,
> otherwise don't.
>
> Barry
>
> "Jorg" wrote:
>
> > 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
> >
> > "Barry Gilbert" wrote:
> >
> > > In the combobox's AfterUpdate event, put:
> > >
> > > Me.AllowEdits=(Me.Status = "Active")
> > > Me.AllowAdditions=Me.AllowEdits
> > > Me.AllowDeletions=Me.AllowEdit
> > >
> > > Barry
> > >
> > > "Jorg" wrote:
> > >
> > > > I have a combo box - Status- with active-closed. when set to "closed" i want
> > > > to lock the data entry for this record.

#7 (**permalink**) 28-Jul-2006, 08:36 AM

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

Barry

"Jorg" wrote:

> Through the form. also once "closedâ€ is applied all other records are also
> not edible.
>
> "Barry Gilbert" wrote:
>
> > When you say the record can be edited again, do you mean through the form or
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> > 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
> >
> > "Jorg" wrote:
> >
> > > 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
> > >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> > > "Barry Gilbert" wrote:
> > >
> > > > In the combobox's AfterUpdate event, put:
> > > >
> > > > Me.AllowEdits=(Me.Status = "Active")
> > > > Me.AllowAdditions=Me.AllowEdits
> > > > Me.AllowDeletions=Me.AllowEdit
> > > >
> > > > Barry
> > > >
> > > > "Jorg" wrote:
> > > >
> > > > > I have a combo box - Status- with active-closed. when set to "closed" i want
> > > > > to lock the data entry for this record.

#8 (**permalink**) 28-Jul-2006, 08:36 AM

Thanks Barry, that was it.

"Barry Gilbert" wrote:

> Ok. You should put this code in the form's OnCurrent event as well.
>
> Barry
>
> "Jorg" wrote:
>
> > Through the form. also once "closedâ€ is applied all other records are also
> > not edible.
> >
> > "Barry Gilbert" wrote:
> >
> > > 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13309
> > > 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
> > >
> > > "Jorg" wrote:
> > >
> > > > 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
> > > >
> > > > "Barry Gilbert" wrote:
> > > >
> > > > > In the combobox's AfterUpdate event, put:
> > > > >
> > > > > Me.AllowEdits=(Me.Status = "Active")
> > > > > Me.AllowAdditions=Me.AllowEdits
> > > > > Me.AllowDeletions=Me.AllowEdit
> > > > >
> > > > > Barry
> > > > >
> > > > > "Jorg" wrote:
> > > > >
> > > > > > I have a combo box - Status- with active-closed. when set to "closed" i want
> > > > > > to lock the data entry for this record.