can't enter info into form

[trish]

hi

i've got my form up and running, kind of. something's happened to my form since i worked on it two months ago.

when trying to add records into a subform on the main form, i keep getting the error message "Cannot add record(s); join key of table "TblUnitEnrolment" not in recordset."

can anyone help..thanks

trish

 

[Fizzio]

Have you changed the recordset of the subform from the table to a query? If so, you must include the joining field that maintains the relationship between the table supplying the data in the main form and the table supplying the subform.

Make sure that the query suppling the subform (and main form for that matter) both contain the field that joins them (usually an ID field)
Also, make sure that your master/child links are correct. These too should be set (usually) to the joining field you defined in your relationship.

 

[trish]

thanks for that fizzio, i'll check my db and get back to you

cheers, trish