Question for the MS Access Experts

D

DrLovely

Most everyone knows that when moving from record to record on an MS
Access 2000 from bound to a table's data, the event of moving from
record to record with the form's record controls updates the table
behind the form automatically with data in the fields on the form.
I.E. - you change a field value and move to another record, it updates
the change to the table that is the "record source".

I'm supposing the native code in Access 2000 .exe is formulating a sql
statement behind the scenes to perform this update.

Is there any way to "capture" that sql text on some event, like on
"before update", when clicking those form controls at the bottom of
the form or "auto form"?

Any response is appreciated.
 
V

Van T. Dinh

IIRC, I read previously that Access actually DAO Recordset to update the
current Record of the Form's RecrodSource rather than SQL DDL.
 
Top