I have form that includes a number of subforms. All of a sudden, it seems like some of the subforms just aren't linking. If I try to enter new data into the forms I get a message that reads "The LinkMasterFields property setting has produced this error: 'A problem occurred while Microsoft Office Access was communicating with the OLE server or ActiveX Control'. All of the LinkMasterFields and LinkChildFields properties are set up correctly, with not spelling mistakes or anything.
Any one have any ideas?
I've found the master/child link a little flakey at times. I've generally had to resort to deleting the subform object from the main form and then re-implementing. I suggests you take a backup of the main form first though so you have some reference.