Pulling Up Fields From one ID

[Accu-Grind]

I would like to create a report that when clicked on it prompts input of an ID#. The report then pulls up information from 2 tables that are linked to that ID#. One is the customer information and the other is information about that ID.



Does anyone know how to create this prompt? Is it a switchboard?

[JoeM]

Create a query between these two tables.
Then make it a parameter query, prompting the user to enter the ID # (see: http://www.gcflearnfree.org/access2013/20).
Then, use this parameter query as the Data Source of your Report. Whenever you run it, it will prompt you for the ID # and return the results.

[Accu-Grind]

Thank you that was very helpful.