subform in report (1 Viewer)

[PicassoB]

Hi Guys I have a problem with a repot, I have inserted a sub form (continuous form)in the detail section of the report - problem is on running the report the form duplicates itself according to the number of records in the form - any idears please i am using 2003

 

[Kowalski]

Add the form in the report's header or footer.
If that is not suitable for you, add a new section "Sorting and Grouping", and add a new group based on the expression "=1" and give it a Header. Place your form in that Header.

 

[PicassoB]

Thanks Kowalski for your responce - I have got the report to work problem now is I have a unbound field in the form to discount the labour hrs (which is a calculated field) this works fine in the main form but does not discount in the sub form (always stays at the defult value) any Idears what I am doing wrong as I strugle with code