Problems with LinkMasterFields property in forms

[Guest]

I've built a database that records training records for staff. I'm currently
having problems entering data onto a subform. The main form contains the
staff details and the subform the training details. It's a one to many
relationship and i'm getting the following error message : The
LinkMasterFields property setting has produced this error: 'A problem
occurered while Microsoft Access was communicating with the OLE server or
ActiveX Control'. Does anyone have any suggestions as to what could be
causing this?

 

[Allen Browne]

Open the main form in design view.

Right-click the edge of the subform control, and choose Properties.

On the Data tab, you will see the LinkMasterFields property. It should
normally contain the name of the primary key in the main form - StaffID or
whatever it is called. The LinkChildFields property should contain the name
of the matching control in the subform (the field that the subform's table
uses to link to the main form's table) which might also be called StaffID.

If your controls have different names than the fields they are bound to, use
the names of the controls rather than the fields.

If that does not solve the problem, there could be another problem with the
database. Press Ctrl+G to open the Immediate Window. Choose Compile on the
Debug menu, and see if it takes you to an error.

If you are still stuck, post a reply for suggestions about references,
decompiling, and Name AutoCorrect issues, and solving possible corruption of
the file.

 

[Guest]

Hi Allen,

thanks for the advice - unfortunately neither of the suggestions you given
have worked.

I've created a new database and exported the tables, queries and reports
into it and created new forms/subforms which seem to have solved the problem
- fingers crossed. However if the error occurs again I'll certainly post a
request as you suggested.

thanks.

 

[Allen Browne]

Fair enough. If you are concerned about how to avoid corruption, see:
http://allenbrowne.com/ser-25.html