I Have a form that has a field (ID) that is "AutoNumbered". I want to go to the last record with a specified value in a second field. Then I want to go to the previous record . The ID field are not in any order so I can't us a query becaued additional field value inputs are necessary.
I know this won't work but basically This is what I want to do:
Dim IDNumber as String
DoCmd GoToRecord, , acLast Where (A_Name) is "Correct_Name" (Obtained from DLookUP)
IDNumber= (ID) -1
DoCmd GoToRecord, , IDNumber