Error: Cannot add record(s); join key of

[Valery]

Hi all,

I am getting this error : Cannot add record(s); join key of tblOccupancy not in record set.

My join key is UnitNum from the tblOccupancy. It is in both the continuous subform as well as in the main form. Also, in both queries of the main form and the subform, I can add records without a problem.

So I am totally confused - have no idea why this particular error would come up. Please help!

Thank you.

Note: Please open reduce sample database attached; open form called frmTenantList, select Unit Number 1. In the form that opens, this is why I am wishing to add a tenant and getting the error.

 

[Ranman256]

the Tenent (master record) must be saved before you can add any children. tOccupancy.

The record selector must turn back to arrow,(not pencil). Then the Autokey gets created.
THEN you can put in child records.

 

[Valery]

Thank you Ranman. Sort of understand - it is like it is in edit mode vs add mode...
So how do I achieve what you are suggesting?