Reports not showing newly changed data

[stebain]

I have a form and subform.
On the form is a reports button that generates a report on the selected
record for the form, and it's related subform data.
Currently, any record additions or deletions made in the subform are not
showing in the report.

[For example, the form is for viewing bank customer information and the
subform shows individual transactions.
When I delete or add transaction records, they aren't showing if I go to
generate the report.
]

How can I assure that the subform changes are posted before generating the
report?

Ta
Steve

 

[fredg]

I have a form and subform.
On the form is a reports button that generates a report on the selected
record for the form, and it's related subform data.
Currently, any record additions or deletions made in the subform are not
showing in the report.

[For example, the form is for viewing bank customer information and the
subform shows individual transactions.
When I delete or add transaction records, they aren't showing if I go to
generate the report.
]

How can I assure that the subform changes are posted before generating the
report?

Ta
Steve

Access does not save new data until you move to another record, close
the form, or explicitly tell it to save the data.
Code the Click event of the button on your form that opens the report:

DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "ReportName", acViewPreview
etc....