Is it possible to insert buttons on forms that will bring up all information/records related to a particular ID?

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 ‘child’ records then all the records related to the ID will be in view or at least via a scroll (or the record navigation controls) within the sub form window.

Another method is to include all the records you want to call up in a query, put ID as a parameter input. You can create a form based on this query to present the information as you want and save and close the form. Then add a button on the form from which to call up the new form, and set this as Open Form, select the name of your new form, and finish. This makes sense on a form on which you can see a summary of the information or the 'primary' table information so you know which ID to put into the parameter box.

The above may suffice for you, but there are other methods, including having a small button against each record line in a multi record view, so that a click on the button calls up the subset of related data, or it can be done so that you click on the ID cell to call up the records, and no button is required, although this will mean how to access records is not obvious to other users unless you put an instruction in. The methods in this paragraph require (as far as I know) that you need to use a Macro or some VBA code.

In the above reply I forgot to say, Hi Fiona and I hope this is what you needed, Regards, Mark