Lock or Prevent Edits on Previous Record

[TJones76]

Hi there!

I've got a multiuser form. I want to lock all previous records from being modified, but I want the user to be able to modify their data on the Current record only...when they move to the next record, then I want the previous record to lock.
What kind of coding / event do I need to accomplish this??

Thanks for your help!


-Tjones76

 

[gol4]

in the forms on current event code like this
<code>
if not me.newrecord then
me.allowedits=false
me.allowdeletions=false
end if
</code>

 

[TJones76]

Thank you!

-Tjones76

 

[Jones007]

Hi,
I'm trying to do this lock records thing again and I've tried this code in the on current event and it does lock the records, but I'm unable to enter data into the new record.

Any suggestions?

Gratefully,
-Agent99

 

[missinglinq]

You already have the "If" statement, why not use the "Else"?
<code>
if not me.newrecord then
me.allowedits=false
me.allowdeletions=false
else
me.allowedits=true
me.allowdeletions=true
end if
</code>

The Missinglinq

&quot;It's got to be the going,
not the getting there that's good!&quot;
-Harry Chapin