See attached picture. I've filtered the form by ProjectNo = 28341, but the record that returns has ProjectNo = 16424. I've checked the backend and found two records with the above project numbers and the same address, but I don't see how this could have occurred. When the view is sorted by ProjectNo in MSAccess, the ProjectNo column shows 28342, 16424, 28340, so it appears that MSAccess knows what the correct ProjectNo is and is for some reason refusing to show it.
Any idea what the problem might be?
I've since found the answer - the problem is that when linking MS Access to SQL Server, a prompt appears asking for the unique record identifier. I selected the wrong field, which caused incorrect behavior.
