Buttons

One way to do this is to add a combo box button on your form (from Tool Box in design mode) on your form. When you add the box to the form you will see 3 options. Select Find a Record on my Form Based on the Value I Select in my Combo Box. Then press Next and choose the field by which you wish to search (ID), and then go on to Finish. You can then go to form view to check the result. You should get a drop down showing 8 values in your chosen field and scroll bar if you have more than 8 in the list. I often prefer to see more than 8 list items at a time. To alter this go back to design view and double click on the combo box to call up properties (or you could right click and select properties). Go to the Format Tab and you will see List Rows about one third the way down which is usually on 8 and you can change this --try 30 or 40. You may need to see more about what records are behind the ID in order to know what to select, particularly (as often the case) if the ID is a number, then you can select to have two columns or more to show you what you are selecting but have the ID as the field for which related records are pulled.

If you are working with a form which shows one record on the screen at a time but with others on other pages, the above will call up the record relating to the ID you select in the combo box. If you have a sub form for to show the related set of