I would like to create a button that allows the operator to skip to the next record in a bound form. The recordsource for the form is a query. When I click "Next", it triggers the btnNext_Click event, where I used VBA to code
If Me.Dirty Then
docmd.gotorecord , , acnext
I get error messages telling me that docmd.gotorecord ,, acNext cannot be executed unless the form is a Continuous form. My form is a Single form. Do I have to make the form unbound and provide all my own opens, loads, record navigations, etc using DAO? Or is there a simpler way around this problem?
I would prefer to let ACCESS handle all aspects of the form and record manipulation, except my application requires a "Next" button that will Undo any changes to the current record (if dirty) then move to the next record in the query's dataset.