Locking Input

[Guest]

The next question have about my work orders project is about preventing
employees from editing data they previously entered.

The nature of the form I am designing is that certain information needs to
be entered at one point in time then at a time in the future, like a week
later the employee needs to be able to recall a record and add comments to it
but without granting them the ability to change their previous entries.

I considered designing a separate form based on a query and I am wondering
if I am on the right track?

 

[Rick B]

Just use code in the ON CURRENT event of the form. Create an IF statement
and set the "locked" property for the fields based on the IF statement.

Rick B