Multiuser form readonly data lock out other users

[Domski74]

Hi All

I have a form linked to a read only query.

I need to be able to lock out other users from pressing buttons on this form when someone else is viewing the particular record (viewed the record first)?

The button has the effect of performing updates elsewhere that effect the readonly query.

Is there a way I can do this?

Thanks

Dom

 

[Domski74]

I made the query editable but locked all the fields so only the button could do the edit. Then when the button was pressed I made a harmless edit like me.field = me.field, this locked the record. Also in the button I perform a check to see if the record is locked and if it is I output a message. To get this to work correctly I had to set the database and form record locking to pessimistic.