OK, let me refrase the last message.

What I want to do is this. Call a macro from a data entry form just prior to on eof the embedded data forms posting
of data to the database engine.

I was thinking that I would assign a macro to the 'Before Record Action' of the embedded data form itself. Past that I am not sure where to go. Is it the connection object that I will need to look at or ?

Specifically I would like to know if this is an INSERT or UPDATE and get access to the SQL statement that is about
to be posted to the engine.

Any help, ideas or avenues for exploration would me most appreciated.

Thanks

Andrew

Andrew Jensen wrote:

If I call a macro assigned to the 'Before Record Action" say

sub InsertNewRecord( oEvt as Object )
....
...
end sub

how do check that THIS action is for a new record insert?

Thanks

Andrew Jensen



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]






---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to