I think you mean that if you open a table to view the records and change a field value can you program a function call based on this change.
Unlike in Excel these are not cells. If you want to do this you would have to open the table in form view. That is design a form using the table as a recordset and open the form in Datasheet view. This will show like opening the table in form view. However, you can program an event against any field in design view to call a function on the After Update event of that field.
Thanks for the reply.
This is within a single table. From my limited knowledge of access it looks as if one can change (update) a record directly like in excel while in the 'table view'.
I hope that made sense.