Reports are showing errors in the data fields

Hello all,



I have a report (upholstery orders) that shows times, quantities and orders details ect. I open this report from a dashboard navigation form using a button (easy enough).

The report opens fine, all data fields/box's/records show up fine and accurate. I have written macro's so that when certain fields (Sales and Works order numbers) are clicked they open another report displaying the necessary information based on the selected fields Data. This again opens fine (no drama's), however, if I then close that form or simply return to the original report (upholstery orders) using the tabs, various fields/records containing data now show "#Error" (which is a slight pain).



If I close the original form and open it again the errors naturally disappear for a while until I move away from it again. I understand there is more pressing and more imaginative problems regarding Access, as it's simple enough to close and reopen, I just wondered if there was any error or requery based solution I can apply to my report, in order to save my colleagues some of that most valued theoretical commodity, time.



Thanks in advance.

Reports are showing errors in the data fields