How to trap record change event

[udit99]

Im trying to disable all text fields whenever user changes the record using that DB tolbar kindof thing....I think.. whaddyacallit...the ADO Data Control ??.......now the problem is that how do I trap a record changed kindof event... I dont know where that is....the other thing I tried doing was tried putting the disable code in the change event of the PK text field...but even that isnt invoked until the user manually changes its value....

[SCIROCCO]

If you use ADO directly you can declare your recordset with the WithEvents property:

Private WithEvents rsSCIROCCO As ADODB.Recordset

Then you will have access to a host of events like:

RecordChangeComplete
WillChangeRecord