I am using dlookup in a report to pull the name of a facility using the cost center that was entered in a form. This is creating some weird consequences.
When the report is displayed in report view, it takes about 10 seconds to look up the name of the facility and to then show the other calculations on the report. It will also create the same delay if I scroll away from the data and back.
However, if I tell Access to show the report in print preview, there is absolutely no delay. I would love to hear any ideas about what is going on. I would prefer to not show the report in print preview, but it is an acceptable work around.
Thanks!
When the report is displayed in report view, it takes about 10 seconds to look up the name of the facility and to then show the other calculations on the report. It will also create the same delay if I scroll away from the data and back.
However, if I tell Access to show the report in print preview, there is absolutely no delay. I would love to hear any ideas about what is going on. I would prefer to not show the report in print preview, but it is an acceptable work around.
Thanks!