cannot add record at the sub form

[mchoud]

HI,

Wondering if anyone can suggest what I am doing wrong. I recently added some subforms with one to many links to a tabbed form that I have.

Since adding the subforms the rest of the form will not let me adding any records. The subforms are working fine, whenever I try and entre data into a field I get "cannot add record, joinkey of xxx tabel not in recordset" in the lower left hand corner.

I've tried copying my query and altering it, as I think the problem may be related to the joins.

Any ideas or suggestions would be appreciated.

Thanks

 

[Ally]

Please don't post question more than once.

First Post

 

[ansentry]

re sub form problem

Have a look at the attached file, it is a bit rough but should give you some ideas.

You will see that I have created 2 new tables, a new form with a subform- both with autonumbers and 1 to many relationship.

So that one BinCard can have many bincard_Details.

HTH


Regards