There is sensitive data in the data base that I wouldn't be allowed to distribute like that. I'll have to put together a sample without that. It won't take long.
It's a 14.8MB file but it doesn't seem to want to upload there. I've compressed it and can email.
I guess this will get you to the file "units.zip"
The form is "Unit Codes".
The field is labeled "Map"
Data Source is Table "Unit Codes" Field "UnitMap" which is defined as hyperlink.
Keying in a URL works. Populating with update query produces exactly what is keyed in but the link does not work in that case.
Is there any explanation of why populating that field with a concatenation expression doesn't work while keying that data in the field works?