Not in Recordset error

[Edgar Thoemmes]

Hi

I have a sub form nested into my main form and I have added a ‘New Record
Button’ Unfortunately this is coming up with the error ‘Can’t Add Records;
Join Key in table tbl_contracts not in recordset.

Could anyone explain to me what this means and how I can fix it?

Thanks

 

[Edgar Thoemmes]

I have a tab control form with a contracts sub form and a contract details
sub form nested inside the contracts sub form. The user would select the
contract from first sub form and then it would display the details of the
contract in the sub form contract details.

What I want is a button so I can add a new contract. The Contract sub form
is a list box with the description from the contract details form as the
rowsource.

I tried to add my add new record button on the sub form contract details but
this didnt work and came up with the error below.

Could this error be to the design of my form? Or is it something I am missing?

Thanks