Lock records after uploading

[mon]

Better repost this

I have data enter databases on laptops for users to enter
their activities. When they exit the program the records
(which have the "sent" field false) are sent to an excel
table to be emailed to me to load on to the main database;
on sending, the Sent field is changed to true. I would
like to ensure that the records on the laptops cannot be
changed after being sent. Sorry, is that clearer? Thanks
Mon

 

[Gerald Stanley]

In the form's BeforeUpdate eventhandler, put in code like

Cancel = {yourSentColumnName}

Hope This Helps
Gerald Stanley MCSD