Join key of table not in recordset??

[Kevin M.]

I have a form with a couple of subforms on it. The main
form filters data from a specific employee, so that the
user can then enter data on that employee on the subform.
I have a different query attached to each of the subforms,
but each of the queries dumps the data into the same table.

After selecting the employee, each of the subforms brings
up existing data on the employee fine, but after entering
new data on the initial subform and then trying to enter
data in the first control on the subsequent subform I get
the following message at the bottom of the screen: "Cannot
add record(s);Join key of table 'tblContentComponents not
in recordset."

I've tried to refresh the record, and have the subform
requery the data after leaving the focus of a control on
the initial subform, but I am either not using the correct
code, or perhaps have the subforms set up incorrectly.
Once I go into the design view on the forms and come back
I can add the new data, so I am assuming that the table
has been refreshed.

Thanks in advance for any help, and thanks for the
previous help that others have been given on this forum,
it has enhanced my understanding tremendously!

KM