This is some inherited code. Always the problem! A form of Optimistic locking.
Anyway, it's a mix and mash. Basically the tables are already opened up before we get to the form. Then on a save button on the form there is an 'if rlock()' block which contains the code to update the record. On top of that, the controlsource's have been set as well! Not well thought out at all! Tristan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Davies Posted At: 24 August 2006 11:12 Posted To: Profox Archive Conversation: Listing current record locks Subject: Re: Listing current record locks Tristan, fwiw I have never found a case where setting your own locks works better than the fox default behaviour. - What buffering are you using? Andrew Davies MBCS CITP - AndyD 8-)# ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. Please contact [EMAIL PROTECTED] with any queries. ********************************************************************** [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

