Hi All
Last night I was working on a new db and wanted to use a few subforms inside a Tab Control. One subform per Tab.
I linked the forms last night and everything was working fine. but loading it today I am getting the following error:
The LinkMasterFields property setting has produced this error: 'A problem occurred while CLDesigns was communicating with the OLE server or ActiveX Control'
Main Form = frm_1_Customers
Subform in Tab1 = frm_1_Projects_Subform
Subform in Tab2 = frm_1_CustomerContacts_Subform
Both subforms have the field customerID which are linked in the relationships to the ID of the customers table.
I Originally I had problems linking the table using the following:
Link Master Fields: ID
link Child Fields: customerID
I searched and found this ttp://access.mvps.org/access/forms/frm0031.htm
so I changed the link fields to something like the following:
Link Master Fields: ID
Link Child Fields: Forms!frm_1_Customers.frm_1_CustomerContacts_Subform.Form.customerID
that didnt work either, I then pressed the button to open the Subform Field Linker Dialog box and pressed Suggest... It offered me the following.
Link Master Fields: ID
link Child Fields: customerID
It then started working but I wondered why it didn't work the first time I tried this but thought using the Field Linker it had done something in the background.
Has anyone got any suggestions? I have read that the error could be something to do with my VBA or language settings on my computer. All I have in the way of VBA so far is a few DoCmd.OpenForm with a Where condition set on a DblClick event on a few text boxes on the subforms.
Thanks
Edit: Bit More Info.
Changed the order of tabs/subforms in the post.
The Main form is a split form.
The error only appears when changing to a record, with tab 2 selected. If tab one is selected and I change to a new record then everything works fine.
I then changed allow additions to "No" on the contacts subform (Tab2) and now the error does not appear.
Both the links are exactly the same so not sure why it is not working. I have checked for typos and everything seems ok.
Last night I was working on a new db and wanted to use a few subforms inside a Tab Control. One subform per Tab.
I linked the forms last night and everything was working fine. but loading it today I am getting the following error:
The LinkMasterFields property setting has produced this error: 'A problem occurred while CLDesigns was communicating with the OLE server or ActiveX Control'
Main Form = frm_1_Customers
Subform in Tab1 = frm_1_Projects_Subform
Subform in Tab2 = frm_1_CustomerContacts_Subform
Both subforms have the field customerID which are linked in the relationships to the ID of the customers table.
I Originally I had problems linking the table using the following:
Link Master Fields: ID
link Child Fields: customerID
I searched and found this ttp://access.mvps.org/access/forms/frm0031.htm
so I changed the link fields to something like the following:
Link Master Fields: ID
Link Child Fields: Forms!frm_1_Customers.frm_1_CustomerContacts_Subform.Form.customerID
that didnt work either, I then pressed the button to open the Subform Field Linker Dialog box and pressed Suggest... It offered me the following.
Link Master Fields: ID
link Child Fields: customerID
It then started working but I wondered why it didn't work the first time I tried this but thought using the Field Linker it had done something in the background.
Has anyone got any suggestions? I have read that the error could be something to do with my VBA or language settings on my computer. All I have in the way of VBA so far is a few DoCmd.OpenForm with a Where condition set on a DblClick event on a few text boxes on the subforms.
Thanks
Edit: Bit More Info.
Changed the order of tabs/subforms in the post.
The Main form is a split form.
The error only appears when changing to a record, with tab 2 selected. If tab one is selected and I change to a new record then everything works fine.
I then changed allow additions to "No" on the contacts subform (Tab2) and now the error does not appear.
Both the links are exactly the same so not sure why it is not working. I have checked for typos and everything seems ok.
Last edited: