O
oldblindpew
I recently changed my main form's Recordsource from the table name, tblJob,
to a query:
SELECT tblJob.*, tblJob.tYear, tblJob.tIDJob FROM tblJob ORDER BY
tblJob.tYear DESC , tblJob.tIDJob DESC;
Now, when attempting to add a new record on the subform, I get this error:
The LinkMasterFields property setting has produced this error: 'The object
doesn't contain the Automation object 'tblJob."
There are any number of things I don't understand here.
1) Why does the query (generated via the Query Builder) contain four
references to tblJob? I mean, how many times do we have to say it? I also
don't understand the purpose or meaning of DESC .
2) After having specified, in the query, ALL fields from tblJob, why do we
have to call out certain fields individually by name from tblJob?
3) After this change of Recordsource, I noticed certain references in my
form to tIDJob were changed by Access to tblFirm.tIDJob.
4) I don't understand the quote marks and apostrophes in the error message.
5) As for the error itself, LinkMasterFields is supposed to be the field
name in the record source of the main form, and it certainly appears to be
present.
6) LinkMasterFields is supposed to match LinkChildFields, but now the one is
tblJob.tIDJob, and the other is just plain tIDJob. I don't know if this
constitutes a mismatch or not.
7) This is not really important, but the terminology should be either
Master/Slave or Parent/Child, not Master/Child.
Thanks for any help you can offer.
to a query:
SELECT tblJob.*, tblJob.tYear, tblJob.tIDJob FROM tblJob ORDER BY
tblJob.tYear DESC , tblJob.tIDJob DESC;
Now, when attempting to add a new record on the subform, I get this error:
The LinkMasterFields property setting has produced this error: 'The object
doesn't contain the Automation object 'tblJob."
There are any number of things I don't understand here.
1) Why does the query (generated via the Query Builder) contain four
references to tblJob? I mean, how many times do we have to say it? I also
don't understand the purpose or meaning of DESC .
2) After having specified, in the query, ALL fields from tblJob, why do we
have to call out certain fields individually by name from tblJob?
3) After this change of Recordsource, I noticed certain references in my
form to tIDJob were changed by Access to tblFirm.tIDJob.
4) I don't understand the quote marks and apostrophes in the error message.
5) As for the error itself, LinkMasterFields is supposed to be the field
name in the record source of the main form, and it certainly appears to be
present.
6) LinkMasterFields is supposed to match LinkChildFields, but now the one is
tblJob.tIDJob, and the other is just plain tIDJob. I don't know if this
constitutes a mismatch or not.
7) This is not really important, but the terminology should be either
Master/Slave or Parent/Child, not Master/Child.
Thanks for any help you can offer.