How to trap record change event

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....

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