Forum Discussion
Subform updating table, but not when you open form individually to input data
I have an employee form connected to the employee table. I have a contacts form connected to the Contacts Table. When I drop in the Contact Form into the Employee form and type a few notes. It update...
> It updates in the table and links the ID's together.
Do you know why? Design the form, and inspect the subform properties on the Data tab: Link Master Fields and Link Child Fields are set, which allow Access to put the parent record's PK value in the child record's FK field.
If you have a standalone form, you don't get this benefit, but you could use code to add it.
Do you know why? Design the form, and inspect the subform properties on the Data tab: Link Master Fields and Link Child Fields are set, which allow Access to put the parent record's PK value in the child record's FK field.
If you have a standalone form, you don't get this benefit, but you could use code to add it.