Adding a field in a subreport

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MIchel Khennafi - 11 Dec 2006 16:40 GMT

I have a subreport SR1 in a report R1.

The subreport SR1 is the result of a query. I modified the query and added a
field in order to print its information on SR1. I do not see the field name
in the field list for SR1. What do I need to do to have the field list
refreshed so tht I can print the new field info?

Thanks so much

Reply to this Message

Allen Browne - 11 Dec 2006 16:59 GMT

Close the main report.

Select the Reports tab of the Database window, and open subreport SR1 in
design view.

Open the Properties box (View menu.)

Check the RecordSource property (first item on the Data tab of the
Properties box, when looking at the properties of the report.) If necessary,
click the Build button (...) beside this, so it opens the query. Verify that
this is the correct query, and the field is present.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a subreport SR1 in a report R1.
>
> The subreport SR1 is the result of a query. I modified the query and added
> a field in order to print its information on SR1. I do not see the field
> name in the field list for SR1. What do I need to do to have the field
> list refreshed so tht I can print the new field info?

Reply to this Message