Quick question

[Yair Sageev]

I have a parent form which has a button that pops up a child form. When I
enter all the data in the pop-up form and then close it, I get the message:

"You cannot add or change a record because a related field is required in
table "Parent Table"

Does somebody know what I'm doing wrong?

Thanks.

 

[Lee T.]

My best guess is that one of the linked columns is not on
the sub/child form. From the sound of the error you have
at least two tables as well as two forms.

Example: your PARENT form is based on PARENT TBL.
your CHILD form is base on CHILD TBL.
In both tbls you have KID_ID and KID_STUFF. Access 2K
(and 2002 and 2003) will automaticly create the
relationships if the column names are the same AND the
data types are the same.

If you don't have both data fields linked between the
forms AND/OR the data fields are not on the form (they
just have to be there but you can hid them...) then you
will get a message like the one you described.

hth
Lee T.