Lock a Record on an on click event

[kimmer7389]

I have a form and after a button is clicked I want only that record to lock so that it can not be edited.

Is it possible to lock a record on an on click event on a button?

 

[KenReay]

Hi

Set Locking type to pessimistic, to cause lock on edit

There are several ways to invoke the edit, but one would be:

In on click event

Me.recordsetClone.Bookmark = Me.Bookmark
Me.recordsetClone.Edit

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[kimmer7389]

I'm not sure how to set locking type to pessimistic. Please explain.

 

[KenReay]

Hi

In the form, set the .Locked property to CurrentRecord,

You can (if you wish) make this the default locking strategy by setting the appropriate value in Tools\Options

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK