Access 03
I have a sales quote form with line item numbers. I have a macro that
increments the item number (using dcount) when a new item is added. It's tied
to the After Insert event of the form.
When the macro runs, it leaves the record unsaved when it's done. If I
attempt to add a SaveRecord line, an error results that tells me I can't use
the BeforeUpdate event (which is maddening, because I'm not using it).
I don't like leaving the record unsaved, because the user my click the save
record button twice.
Rick Brandt - 23 Apr 2007 19:07 GMT
> Access 03
>
[quoted text clipped - 9 lines]
> I don't like leaving the record unsaved, because the user my click
> the save record button twice.
Use BeforeInsert, not AfterInsert. When you change the record AFTER you
have inserted it then you are re-dirtying it.

Signature
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com