Thanks John,
That does the job.
Cheers,
Robin Chapple
At 14/02/2015 12:01 AM, you wrote:
Or put the code in the form's On Dirty event.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
On Feb 13, 2015, at 12:36 PM, graham@mandeno.com [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:
Hi Robin
Have you tried moving your code to Form_BeforeUpdate instead of Form_AfterUpdate?
It appears Form_AfterUpdate will not create an endless loop as I feared, but it will still cause the record to be updated twice, which is undesirable.
Best wishes,
Graham
__._,_.___
Posted by: Robin Chapple <robinski@westnet.com.au>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (13) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar