Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Reports _ Report Subform Parts

Posted by: xjohnson May 23 2019, 02:14 PM

Hello,

On my form AFRs there is a 'Preview AFR' button to show the report for 'AUTHORIZED FIELD RETURN'. On the report I attempted putting the parts associated with this AFR Number.

The subform has the parts listed and quantities but I don't know how to make it 2 columns to allow for maximum 30 parts. Also a way to put 'Qty' and 'Part Number' above the parts.

Can someone please help?

Thank you

Posted by: June7 May 23 2019, 05:08 PM

For multi-column subreport, review https://social.msdn.microsoft.com/Forums/office/en-US/00d74046-bcea-427b-9a3e-194ef85e6061/sub-report-with-columns

Put subreport labels in its report header and set header to Visible Yes or use label controls on main form to show "Qty" and "Part Number".

Posted by: xjohnson May 23 2019, 05:16 PM

Thank you I will try tomorrow morning