Programmaticlly change report recourd source

[Ashley]

I'm working on report that needs to be used to print individual as well as a
block of unique IDs. I have two queries -

One is a pass-through with a SQL backend that only prints one ID.

The other is a regular Access query with a simple inner join between an
Access table which holds the IDs I wish to report and a pass-through query
(SQL backend) which contains all data needed.

Any help will be greatly appreciated!

 

[Duane Hookom]

I couldn't find a question in the below message. If you have a specific
question, please feel free to ask.