Jim Dettman
jimdettman at verizon.net
Mon Aug 8 06:28:18 CDT 2011
My guess is that it needs a fresh record and wants to place a read lock to detect if it is currently being edited by another user. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Benson Sent: Sunday, August 07, 2011 01:12 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Setting .AllowEdits programmatically Maybe because the record source has to be rechecked to see if it is an editable recordset? On Aug 7, 2011 12:13 AM, "jwcolby" <jwcolby at colbyconsulting.com> wrote: > Causes the current event to fire. > > I was running code > > .AllowEdits = mblnFrmEditMode > > and the current would fire immediately. I ended up having to wrap the code in the following to > *minimize" the current event firing even when it was already the same state. > > If .AllowEdits <> mblnFrmEditMode Then > .AllowEdits = mblnFrmEditMode > End If > > No idea why this happens but it does. I also have no idea whether setting the .AllowDelete and > .AllowAdd causes a current event to fire. > > -- > John W. Colby > www.ColbyConsulting.com > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com