Use a macro to display related records when you move between records on a form

Use a macro to display related records when you move between records on a form

  1. Open the first form in Design view.

  2. Create a macro.

    How?

  3. In a blank action row, click OpenForm in the action list.

  4. Set the Form Name argument to the name of the second form, and then set the Where Condition argument to display the related records you want in the second form. For an example, click .

  5. In form Design view, set the OnCurrent event property of the first form to the name of the macro.