Join Key of [TABLE] not in recordset error.

[adammitchell23]

Hi all,


Bear with me, I'm a novice! I'm building a database for a population of animals. I have a form ("AnimalEntry") which updates several tables and is used when new animals enter the population. This form works fine to update existing animals' records, but when I try to add new records (the whole point of the form) it won't add records to one of the tables, giving the error "Cannot add record(s); Join Key of table "MainColonyMembership" not in recordset". The only difference between the table "MainColonyMembership" and the others (as far as I am aware) is that this is a one-to-many relationship and the others are one-to-one relationships. All tables are joined by the field "Animal ID". However, when I use a form elsewhere to add records to just the "MainColonyMembership" form (which I do when an animal changes colony) it adds records just fine.
I have tried to upload my database but it's repeatedly failed (I'm at a research station in the Kalahari and internet is both crap and super-expensive!).

Thanks!

Adam

[drunkenneo]

Could you Paste the recordset code, so it will be more clear to understand.

[John_G]

Hi -

This is admittedly on a guess, but based on your description I suspect that the recordset for your form (which I think must be a query) is missing a required table. Does your database have defined relationships in it? If so, does the recordsource query for your form have a table from only one side of a relationship, but not the other?

As I say, it's only a guess, but the error message you are getting is suggestive of something like that, where Access cannot add required data.

HTH

John