When you move between records on a form, you can display related records on a second form by running a macro or an event procedure in response to the first form's Current event.
Use a macro to display related records when you move between records on a form
Use Visual Basic for Applications to display related records when you move between records on a form