I have a form that is loading by [Project]. Then I have a "Next Record" command button in the footer of the form. This button works fine to go from one record to the next record. But then I also have a combo-box on the form that allows the user to "Find" a record. The afterupdate event takes them to the desired record just fine.
But here is the problem.. After the afterupdate event has taken the user to the desired record, the "Next Record" button no longer works. Instead, they are taken to a blank record.
Here is my next record VBA code:
DoCmd.GoToRecord , "", acNext