Because I overlooked the automatism once again and wondered about the displayed data:
Does anyone know a way to prevent the LinkMasterFields and LinkChildFields subform properties from auto-populating when changing the subform data source at runtime?
Access sets this property automatically when it finds data fields with the same name in the data source of the main form (PK) and the subform.
When inserting in design view, it doesn't bother me. At runtime, I find it very annoying. Why does Access change the application developer settings?
Note: renaming the respective affected data fields using an alias helps, but I regularly forget to do that
Example see attached file.
Does anyone know a way to prevent the LinkMasterFields and LinkChildFields subform properties from auto-populating when changing the subform data source at runtime?
Access sets this property automatically when it finds data fields with the same name in the data source of the main form (PK) and the subform.
When inserting in design view, it doesn't bother me. At runtime, I find it very annoying. Why does Access change the application developer settings?
Note: renaming the respective affected data fields using an alias helps, but I regularly forget to do that

Example see attached file.
Attachments
Last edited: