Lock records after uploading

  • Thread starter Thread starter mon
  • Start date Start date
M

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
 
In the form's BeforeUpdate eventhandler, put in code like

Cancel = {yourSentColumnName}

Hope This Helps
Gerald Stanley MCSD
 
Back
Top