I am new to a VBA and only a little exposure to Access 2010. I’ve been battling a problem for a few days. I have a mainform with 2 subforms. Data in subform 2 is filtered to the record selected in subform1. I have no problems with data between the mainform and subform1. The frontend is in MS Access 2003 and the backend is a SQL server database.

The particular problem I am having is when I click in subform2 to add/edit data, the last...