469,621 Members | 1,714 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,621 developers. It's quick & easy.

Paste Multiple records - AfterInsert event

Hello,

I have a form where a user may paste multiple records. The form has an
AfterInsert procedure. The procedure copies the newly inserted record
into a different table for audit purposes.

When one record is pasted, all is working fine. If multiple records
are pasted, the AfterInsert event gets fired before the Paste
Confirmation Dialog Box, therefore no records are inserted into my
audit table.

Is there a way to trap the Paste Confirmation Dialog Box, so I could
add the code after the dialog has closed? Or any other suggestion on
how I should do this?

Thanks for your help!
Andree
Nov 12 '05 #1
1 4406
andree wrote:
Hello,

I have a form where a user may paste multiple records. The form has an
AfterInsert procedure. The procedure copies the newly inserted record
into a different table for audit purposes.

When one record is pasted, all is working fine. If multiple records
are pasted, the AfterInsert event gets fired before the Paste
Confirmation Dialog Box, therefore no records are inserted into my
audit table.

Is there a way to trap the Paste Confirmation Dialog Box, so I could
add the code after the dialog has closed? Or any other suggestion on
how I should do this?

Thanks for your help!
Andree


Try using the AfterUpdate event instead of the AfterInsert event.

--
MGFoster:::mgf
Oakland, CA (USA)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Sean Howard | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.