I want to set the default value of 2 fields in a parent form and 2 fields in a subform when a new record is added.
We have 1 table (Table A) containing 1 record having 4 fields that is used to retain the values that I want in the forms.
We have a parent form (Form 1) that contains a subform (Form 2). Table A is not a data source for either form. Other tables are required as the data sources. There are at least 15 form controls on each form.
When a new record is entered into Form 1, we want 2 fields from Table A to be the default value in 2 form controls. Same when a new record is entered into Form2, we want 2 fields from Table A to be the default value in 2 form controls.
Tried setting the default value of each form controls to the corresponding value in the Table A field but get a #Name error.
Any experts out there that can suggest how I might approach solving this? Thanks!