Question Form / Sub-Form

Tomhoneyman

New member
Local time
Today, 21:24
Joined
Feb 16, 2016
Messages
3
Hi,

I have an issue where I have a sub-form within a form.
The form gives detail of inspections, i.e. location, detail, dates.
The sub-form (Linked by 'Inspection ID' on the main form) gives the costing's on a tabbed sub-form.

When I generate a report and there is no data inputted into the sub-form, nothing is shown in the report. As soon as anything is inputted into the sub-form, the record is displayed on the report.

Can anyone help how I can get this to be shown within the report when there is nothing inputted.

Tom
 
Sounds like the report's source is a query based on the form's source and the sub-form's source. It sounds like the way you have joined these is via an INNER JOIN, which is effectively criteria--your data has to be in both sources for it to show in the query.

To fix this you should make that INNER JOIN a LEFT JOIN. In design view of your query, left click on the line that joins your data sources and choose 'Join Properties', then in the dialog that appears choose the option that shows all the records from your main table (the one your form is based on). That should fix your report to show records without matches in the sub form.
 
Excellent, Worked a treat, thank you.
 

Users who are viewing this thread

Back
Top Bottom