I feel like I have done adequate research and come up empty handed so I now pass it off to you. Pretty simple, really: I am getting a type mismatch error in the immediate window with the following line:
?Dlookup("LastUpdated","tblBranchLocations","LocationID = 1")
The table is linked table to an Azure DB.
The field is this DateTime Extended field which seems to be a source of many problems.
I can switch "LastUpdated" to a different field like "Address1" and it works fine. But when I switch to a datetime extended field, I am getting the error.
I also tried it with similar fields in a different table to identify the problem as the datetime extended fields.
I'm stumped as to why Dlookup would return a type mismatch when it returns a variant. Advise please, and thanks!