I have an Access 2007 database with a form and sub-form.
oNE to many relationship between form and sub-form.
When I scroll with the data control, it scrolls ONE beyond the last record.
So, is there are 2 sub-records, it will scroll to #3.
If I click on 'goto last' button, it goes to record 2, which is correct.
But if I scroll with 'move next' button, it will go to blank record 3.
Sub-form recordset is attached to a single table.
Is that the issue? Do I need to use recordset with association between both tables?
The problem is that users accidently add a partial record, when scroll to last record, instead of using the 'addnew' button.
Also, how can test for # of records, move to last, and delete (if desired) in vba code?