Go To Next Record
Posted on 1998-07-10
My sample application has a main form (Form1) with two subForms (subFormA) and (subFormB). The source object for subFormA is (FormA) and for subFormB is (FormB). The Recordsource for FormA is (TableA) and for FormB is (TableB).
When focus is lost in the last TextBox on subFormA or subFormB, I want the application to advance to the next record in the associated table.
I have tried the following with no success: (example syntax for subFormA, FormA, LastTextBox)
DoCmd.GoToRecord acDataTable, TableA, acNext
Please HELP! -- Thanks