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


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

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