Report referencing incorrect data

[charcurley]

The Access 2000 database that is in place has been in place for 12 years. The backend was just updated from Sybase SQL to Microsoft SQL server. It was just noticed that a document that pulls in information depending on the file that is opened in a screen is referencing the incorrect data when it references a module or a field on the screen? If the data is in a query it references the correct data BUT if I say for example: forms![dataform]!CustomerCode it MAY be the data from the previous screen?? As I said this has only begun to happen since the upgrade of the data. Any thoughts out there? Thanks for any help.

 

[Remou]

Have you installed the lastest version of Jet?

http://support.microsoft.com/kb/251289