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...