LinkMasterFields Error Message

[ridgerunner]

Can anyone tell me what I might have done to cause this error message when I
attempt to go from design view to form view:

"LinkMasterfields property setting has produced this error: The object
doesn't contain the automation object 'tblQst'.

 

[John W. Vinson]

Can anyone tell me what I might have done to cause this error message when I
attempt to go from design view to form view:

"LinkMasterfields property setting has produced this error: The object
doesn't contain the automation object 'tblQst'.

Well... what IS the Link Master Field value?

Normally it should be just a fieldname, or the name of a control on the
mainform. I'm guessing that you have it as tblQst.fieldname - if the
mainform's recordsource is tblQst, try removing the tablename and just use the
fieldname.

 

[ridgerunner]

That is the Link Master Field name. If I try to eliminate the tblQst and
only use the the field name, I get a message box asking for a value. The
Link Child Field Name is the same name without a table reference. The master
form is based on a query. Could that be causing the problem?

 

[John W. Vinson]

That is the Link Master Field name. If I try to eliminate the tblQst and
only use the the field name, I get a message box asking for a value. The
Link Child Field Name is the same name without a table reference. The master
form is based on a query. Could that be causing the problem?

Yes, if the link master field isn't in the query. Perhaps you could open the
mainform's recordsource query in SQL view and post it here, along with the
actual contents of the master link field.

Do note that the master link field must be *a field*, not a table!

 

[ridgerunner]

Here is the SQL for the query.

SELECT tblQst.[DM Category], tblQst.QstWithPtVal, [DM Checklist Table].[DM
Category], [DM Checklist Table].[Pt Value and Question]
FROM [DM Checklist Table] RIGHT JOIN tblQst ON [DM Checklist Table].[DM
Category] = tblQst.[DM Category]
ORDER BY tblQst.[DM Cat Sort Order], tblQst.QstWithPtVal DESC;

The actual contents of the master link field are category names:
SALES
PRODUCTION
CUSTOMER SERVICE
CLEANLINESS
SAFETY
GENERAL

Thank you for looking at this.

 

[John W. Vinson]

Here is the SQL for the query.

SELECT tblQst.[DM Category], tblQst.QstWithPtVal, [DM Checklist Table].[DM
Category], [DM Checklist Table].[Pt Value and Question]
FROM [DM Checklist Table] RIGHT JOIN tblQst ON [DM Checklist Table].[DM
Category] = tblQst.[DM Category]
ORDER BY tblQst.[DM Cat Sort Order], tblQst.QstWithPtVal DESC;

The actual contents of the master link field are category names:
SALES
PRODUCTION
CUSTOMER SERVICE
CLEANLINESS
SAFETY
GENERAL

Thank you for looking at this.

I'd suggest that the Master Link Field property should be set to

[DM Category]

with the brackets and no quotes. Is it? If not, what IS it?

 

[ridgerunner]

You are right and for some reason the subform wizard did not insert the
brackets. I just re-created setting up the form and the brackets are there
and everything works.

Here is the SQL for the query.

SELECT tblQst.[DM Category], tblQst.QstWithPtVal, [DM Checklist Table].[DM
Category], [DM Checklist Table].[Pt Value and Question]
FROM [DM Checklist Table] RIGHT JOIN tblQst ON [DM Checklist Table].[DM
Category] = tblQst.[DM Category]
ORDER BY tblQst.[DM Cat Sort Order], tblQst.QstWithPtVal DESC;

The actual contents of the master link field are category names:
SALES
PRODUCTION
CUSTOMER SERVICE
CLEANLINESS
SAFETY
GENERAL

Thank you for looking at this.

I'd suggest that the Master Link Field property should be set to

[DM Category]

with the brackets and no quotes. Is it? If not, what IS it?