I haven't a clue where to start with this.

[neilhoop]

I have five tables that hold all the data required to fill in this certificate. (See attached PDF)

First table is Certs. This holds CERTIFICATE NUMBER, ID numbers for CLIENT / LANDLORD'S DETAILS, JOB ADDRESS, four APPLIANCE DETAILS, four INSPECTION DETAILS including DEFECTS and REMEDIAL ACTION TAKEN and DETAILS OF WORK CARRIED OUT etc Section.

Second table is Client. This holds the data for the CLIENT / LANDLORD'S DETAILS section

Third table is Job. This holds the data for the JOB ADDRESS section and also the Landlord's ID number.

Forth table is Appl. This holds the APPLIANCE DETAILS and also the Job address ID number.

Fifth table is Inspect. This holds the INSPECTION DETAILS, DEFECT(S) IDENTIFIED and REMEDIAL ACTION TAKEN and also the Appliance ID number.

I have created a form based on Certs with sub forms for all the other sections and can now, after much time and effort, create a 'Certificate'

I now need to print all this onto the attached certificate.

Can anybody guide me in the right direction?

 

[NigelShaw]

Hi

Without looking at Access as I'm putting my lad to bed, I'm pretty sure there is an option to create a report from a form. Concentrate on getting the data right first. Once you have it, then make the visual layout to what you want.

Ns

 

[neilhoop]

I've looked, I've searched and I'm still none the wiser.

 

[Mr. B]

Try taking the exact same approach to creating your report as you did creating your form. Use a main report (like your main form) and crate subreport, just like you did with your subforms. The subreports can be linked to the main report exactly as in the forms.

You should be able to use the same queries in your report and subreports that you used in your form and subforms.

 

[neilhoop]

Thanks for that I'm well on my way now.