you can add a command button that, when clicked, will pop open the form that contains the necessary data. Find out how to create a pop-up form in this Access tip. The Microsoft Access Order Entry ...

How to create ... Form In Layout View, right-click on the row and select Insert; choose where you want to place the row. Also read: How to Create, Edit, and Delete a Table Relationship in Access.

We've connected the two tables by creating primary keys and ... you can move between records on both the form and the Recordings Table subform. The next part of this tutorial will show you how you can ...