Stopping Edits and Additions on a particular record

[kisingh]

hi,

can anyone tell me how to stop additions and edits on a particular record in a form, plus the subform that the main form contains,
im trying to put the event behind the change of a text box, shipped date, so when its changed you cant add or edit the record which is the order.

cant anyone point me in the right direction?

cheers

 

[Laurentech]

In the afterupdate event of your shipped date textbox, lock all the controls on your form. Put this same code in oncurrent so if user is looking at old records they will not be able to change them.

If not isnull (me.shippeddate) then

me.control1.enabled=false
me.control1.locked=true

me.control2.enabled=false
me.control2.locked=true

else

me.control1.enabled=true
me.control1.locked=false

etc...

end if