I have a form in which several fields have default values. However, when I create a new entry and save it only saves the those default values in fields which come from the primary table. Fields that in subforms that come from related tables are not automatically saved.
For Example
Primary Table:
tblClients
Client_ID - primary key
more fields...
Child Table:
tblContact_Permission
Permission_ID - primary key
Client_ID - fkey
Permission - Yes/No
I have a subform which contains the field Permission as a combobox and the default value is set to yes. However it will only create a record in the Contact_Permission table if I click the combobox for each record and re-select yes! This was not part of the master plan (efforts at world domination are also ,sadly, falling behind)
Any suggestion
Thank you
For Example
Primary Table:
tblClients
Client_ID - primary key
more fields...
Child Table:
tblContact_Permission
Permission_ID - primary key
Client_ID - fkey
Permission - Yes/No
I have a subform which contains the field Permission as a combobox and the default value is set to yes. However it will only create a record in the Contact_Permission table if I click the combobox for each record and re-select yes! This was not part of the master plan (efforts at world domination are also ,sadly, falling behind)
Any suggestion
Thank you
