Can't get flexgrid row on exit from subform.

[sfatz]

I am using Access 2003.

I have a form with a sub-form and a flexgrid.
The flexgrid shows a summary of hours for each day of the week for each project. (Projects down col. 1, Sun - Sat across top from col. 2 - 8).

When a user clicks on one of the projects in the grid, the sub-form displays all rows in the dB for that selected project. The user can then add or modify data in the subform. When the user exits the subform, or clicks on an Update command button, the flexgrid gets updated to show the changes.

Everything works fine except when the user clicks on a project in the flexgrid to bring up the details for that project. The OnExit routine fires, updating the flexgrid, and then setting focus to the first control on the main form. The subform now shows the details for the first project, which may, or may not have been the project that the user clicked on.

I need to find a way of trapping what project (row) the user has clicked on in the flexgrid in order to reset the filter in the subform.

I hope that I have explained well enough what I am trying to do and that someone out there help me with this little problem.

Thanks in advance for all the help.