Hello forumers!
First post, hoping you guys might be able to help me with this problem. Been searching the internets for info but haven't found anything specific to my situation.
So anyway! I would like to update our Access database from running on Access '97 to 2003. I have done so within a test environment (not the live servers) and all is well, except some reports which worked fine in '97 are now showing #Error in the display fields. I've attached a screenshot of said report (parts blurred for confidentiality).
I'm guessing the problem is in the first field with an #Error (Order Subtotal), since the other fields that also have an #Error reference this field as well. That field contains the following code:
=[Order Details Subform].[Form]![Order Subtotal]
(And no the field name is not the same as the name of the label next to it; I came across that possibility in my searching for a solution)
I am not an Access master and I did not create this database originally, so I'm a bit lost. Looking for any clues as to what might be causing this problem. This report displays fine in '97 and gets these errors in '03, so it has to boil down to some difference between the two versions (or some problem during conversion maybe, although no errors were reported during conversion).
Thanks in advance for any help offered, I appreciate it!