Reading a form’s underlying record’s lock status

Topic

New Reply

When I create a delivery docket, there is code in the print button that ticks boxes in the relevant job record in the job table, but if the job is being viewed a different way already, then the record is locked and the boxes are not ticked. What I would like is a bit of code that would check the lock status of the underlying record so I can abort the print process with a message saying that someone else has the record open.

I can write the rest once I know what I need to check for and how.

Thanks in advance. :):)

Reply | Quote

Replies

There is some code for a function that does that job in this post. The idea is to open a recordset and try to edit it. If there is an error, then the record is locked.

Reply | Quote