Originally Posted by
Bulzie
If I read your issue right, you have a Form(Navigation) and Report and on the report you have some totals. You want those totals to be on the Navigation form as well(regardless if the report is open or not). If that is the case, put an unbound field on the form and use the same formula or code you use in the report (put in OnOpen event on form) to calculate this same value in the field(on the form). If data changes and you want the form to update, maybe do a timer to requery the form.
YES! Thank you. That's exactly right. I put the unbound field on the form, but the issue is there is no actual formula used in the report. It simply is "=Count(*)"(through the "Totals" section in the Report Design).
I tried this in the OnOpen event of the form:
Code:
Me!Textbox44 = Me![Reports]![ExpiredLeasesReport].[TxtboxTotalExpired]
Textbox44= Unbound field on the form
ExpiredLeasesReport=Report
TxtboxTotalExpired=Field on the report
It says that "Microsoft Access can't find the field "Reports" referred to in your expression. I am pretty sure the syntax is off, but I have been trying all morning and nothing seems to work. I am obviously quite novice at this.