MS Access Error: The object does not contain the automation object
When entering a new data record, the error is displayed:
The LinkMasterFields property settings have caused this error:
The object does not contain the automation object tblBase_Player
Here, when entering the first value into a data field of the subform
In the subform, the parent detail reference must always be specified. In a subform, there is a field that refers to a field or value in the main form.
This value is missing when creating a new record. You have to set it before.
Remove parent entries and reduce the subform with the data source so that only those records that are set in the main filter are displayed.
Delete the link master fields and link child fields entries
To do this, select the subform and remove the entries under link in Properties.
Reduce the records
To do this, click in the subform and then open the entry on the data source.
Here you have to change the SQL-Select entry.
Reduce the records in the subform, depending on the filter field in the main form:
SELECT * FROM tbl_Football
Here is the data source in design mode. You can see that with * select all fields and the filter refers to the ID field.
The subform always refers to the selected record in the main form. This is why you have to make this entry in the data field automatically when you create or append records.
The automatic default value is obtained by entering a reference to the filter field in the main form in the field: Default value.
Example: as a default value for new values
Default Value: = [Forms]! [Frm_Master]! [CtlFilter_Control]
Test when entering new records:
New records have been added, marked blue here.
It is important that the IDBase_Player was entered automatically as the default value
The LinkMasterFields property settings has produced this error:
The object doesn’t contain the Automation object tblBase_Player