6 PDF Report from 6 table output to 1 location

[bestfc01]

Hi there,
Im creating a database for a server that has four nodes. We require to output all reports to a folder so we can send them to our customer prior to shipping the server out the door.

I've tried so many codes, but these dont seem to work as i have 6 different tables as four table has 150 field names.

I need all files when outputing to save to the location E:/Company/Customer/ Then we can create a new folder for the customer relevent build. These also need to save as PDF's.
All tables have the same field "Customer P/O" and are linked via relationships to allow use to run queries with multiple table information.

Table: Chassis Report: Chassis Report: Node QA
Table: Node 1 Main Report: Node 1
Table: Node 2 Main Report: Node 2
Table: Node 3 Main Report: Node 3
Table: Node 4 Main Report: Node 4

I no i will most likely have to enter the "Customer P/O" number six times, but this will save me so much time with the standard output to macro. If we could get around entering the "Customer P/O" number six times that would be even better.
Thanks In Advance

 

[spikepl]

I have read your post twice, and do not understand what your problem is and what exactly you want help with. My advice would be to show your post to a colleague/friend not involved in this, and modify it until he/she understands it. Then post the result here.

 

[bestfc01]

Thanks but have solved this last night after :banghead: over it for several hours.

What i was after was a piece of code that allows me too output 6 different report, from 6 different tables (record sets).

To complete this i had to use a combo box to be my search source. So when the combo box is changed to a particular record, it will also display any record with the same (number in my case) data from the other 4 tables.

This save me typing in my number six time, all i have to do is show access where the files are going to be saved and click ok for each report to save it.

If anyone is looking to do a similar thing I can post the code on here.