Originally Posted by
John_G
Probably not. The problem is probably has to do with the values in the PhysicianID fields. They may look the same - but are they really? What is the data type of that field? It should be the same in both tables. If it is character type, and the data is coming from a source that is not MS Access, then there may be some extra non-visible characters in there that cause Access to think the fields are not equal. The fact that you can change the PhysicianID to its "correct" value and then have the query work (in the form) suggests that is the problem.
If you can, take a look at the code that transfers the data from the web to your back end tables - something may be adding an extra blank or a CRLF to the data, which you can't see but is causing the mis-match problem.