Not allow any change after 3 days

[xaysana]

Hi there,

I have a subform sfmain which bounds to tblrsales. In subform, i like to block a data entry person not be able to edit record(s) after he entered in last 3 days. But the admin person can do changes.

Do you have any idea please?
Thank you
Regards,

 

[gemma-the-husky]

use the current event to test the record

effectively. this sort of thing. (need's some flesh on these bones, though)

form currentevent
if oldrecord and nonadminuser then
lock all the controls
else
unlock all the controls
end if