I have a form with 2 subforms, the second subform is linked to a field on the first subform, using the following properties:
Link Child Fields - ClientCode
Link Master Fields - [FirstSubformName].Form![ClientCode]
The link works fine and I can view & edit client details in the second subform related to the selected client in the first subform.
As soon as I try to add a new record in the second subform I get the following error message:
A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control
Close the OLE server and restart it outside Microsoft Access Then try the original operation again in Microsoft Access.
Can Anyone PLEASE help…
Thanks
Leigh
Link Child Fields - ClientCode
Link Master Fields - [FirstSubformName].Form![ClientCode]
The link works fine and I can view & edit client details in the second subform related to the selected client in the first subform.
As soon as I try to add a new record in the second subform I get the following error message:
A Problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control
Close the OLE server and restart it outside Microsoft Access Then try the original operation again in Microsoft Access.
Can Anyone PLEASE help…
Thanks
Leigh
