display same ID records seperately

[thawstone]

Hi there, I have a subform to select which Managers will get a Corrective Action Report based on a single Non-Conformance ID. The queried information looks like:

ID Managers
01 QA Mgr
01 Maintenance Mgr
01 Shipping Mgr

How can I access this data 1 record at a time in order to have each Manager name print on a separate Corrective Action Report?

 

[GinaWhipp]

How are the Managers choosen? Is there a checkbox somewhere?

What is the unique identifier (PK)?

 

[nanscombe]

That would raise quite a few questions. Here are a few to be going on with:

Are all three managers in the same record or separate ones.

Will the report be output in electronic format, eg PDF, which could mean producing a separate report for each manager.

Will the report be in printed format which could mean just a separate page in a combined report which could had separated.

Would the reports be produced one at a time or would they be produced in a batch, ie all items for a single manager.

 

[thawstone]

The Managers are chosen from a combo box linked to a junction table between the Non-Conformance table and the Managers table. The junction table lists Non-Conformance ID#s and the corresponding (combo box chosen) Manager ID #s - each a separate record. (One Non-Conformance ID may correspond to as many as 8 separate Manager IDs) I would like to be able to click a command button that transfers the manager's names and titles (in the Managers Table) each to its own Access Corrective Action Report, separately or in a batch.

The thought occurred to me that I could have a command button in the subform containing the combo box that would transfer the Manager's names to the Corrective Action Reports as each is chosen bypassing the need to separate the records after they've all been chosen.

I'm a little bit over my head with this project.

 

[GinaWhipp]

Hmm, have a look at...
http://www.access-diva.com/vba3.html