By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,435 Members | 2,891 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,435 IT Pros & Developers. It's quick & easy.

Paste Multiple records - AfterInsert event

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.