Passing Report Data

[martinw]

Can data in a report be passed onto a data entry form?

I need the results from computations that take place in a report to be passed un to a form to put that data in a new table.
Thank you in advanced for your assistance.
martinw

 

[Pat Hartman]

The only way you would be able to do that is by placing code in the appropriate report section's Format event. You could then use AddNew to add new rows to some table or use Edit to modify existing rows. Look up help for these methods for sample code.

Storing calculated values is not recommended. As soon as one of the underlying values is changed, the stored value becomes invalid and there is no way to identify that situation. Simply recalculate the totals in a query as needed.

 

[martinw]

Passing report data reply

Pat,
Thank you for your suggestion. I will try and find the coding to do this. The reason I wish to di this is maintain historical records of the time spend per day.
Thanks again for your assistance.