Im not sure how to explain this more clearly but I have ran a query
based on client# and I have successfully ran a report based on that
query. Now I want to change the client# in the query and run another
report, using the same report format.
You need to use one of Access' most powerful features: a Parameter Query.
Rather than using a criterion like "A123" to select client A123, you can use a
criterion
[Enter client number:]
in square brackets. Base the report on this QUery (or change your existing
report's Recordsource property to the name of this query). Now when you run
the report it will prompt you to enter a client number, and report on whatever
client you type in.
Even better, create an unbound (nothing in its Control Source) Combo Box on a
form, allowing the user to select a client ID from a list. Use
=[Forms]![NameOfForm]![NameOfCombo]
as the criterion. You can put a command button on the form to open the report,
or open it in the combo box's AfterUpdate event.