accessing current record in a form

[Guest]

I have a subreport data grid.

When a user changes a value a particular field in the data grid,
I want to update another field for that particular record.

example: user puts a value into 5th row, 1st column of a data grid.
on the before update or after update event. another value will automatically
be
entered into the 5th row 2nd column of the datagrid.

what might the code be?

thanks

 

[Duane Hookom]

You can't change any values in a subreport. BTW: what's a "subreport data
grid"?
Access has records and fields rather than rows and columns.