I have a strange problem. I have an Access app that has been running for many years.
All of a sudden there is some subforms that display all data and does not filter according to the master record. But only on some PC's. It used to work fine on the se machines, but all of a sudden, without changing/reinstalling the app, the subform data is not filtered anymore.
E.g. I have a form showing a student and a subform showing his subjects.
The properties for Link Master- and Link Child Fields are filled in.
Now instead of showing the student's subjects, it shows all the subjects for all the students.
The data in the (SQL) database is still fine, just seems to be on display.
Something with a windows or access service pack? Something else?
All of a sudden there is some subforms that display all data and does not filter according to the master record. But only on some PC's. It used to work fine on the se machines, but all of a sudden, without changing/reinstalling the app, the subform data is not filtered anymore.
E.g. I have a form showing a student and a subform showing his subjects.
The properties for Link Master- and Link Child Fields are filled in.
Now instead of showing the student's subjects, it shows all the subjects for all the students.
The data in the (SQL) database is still fine, just seems to be on display.
Something with a windows or access service pack? Something else?