Report updating......

[barrowfordred]

Seeing as a report gets its information from a table. I'd have expected the report to updated when ever the table is modified. Seems not, unless I'm doing something wrong (likely). What I mean is, if I add another field to a form or table, this isn't added to the report automatically. The best way I've found to do it is to delete the report and start again adding the extra field. Not correct I know but the only way I could figure out how.

 

[Rich]

Just drag the additional field(s) off the field list and add them to the Report

 

[barrowfordred]

I've managed this once, now I've added another field to the database I cannot add this to the report. When I drag the new field onto the report I get 2 boxes. One needs to be in the page header and the other in the detail part of the report. BUT both boxes moved together, I can't separate them????

 

[Rich]

You're talking about the label associated with the textbox, drag it away from the textbox, copy it, delete it, then re-paste it back where you want it

 

[barrowfordred]

Thanks for that.

 

[barrowfordred]

Thanks for that