G
Guest
I have a command button linked to a form that holds the name, date, title
and trainer of all our training classes (frmCourse). I have another command
button linked to to another form (frmBannerRespondent2) where I enter
information applicable to the class itself (date, course number, respondent
number, trainer, Yes/No boxes, comments, etc.).
When I click on the command button linked to the Banner form, I can enter
the information, but if I go to change something I get the message:
You cannot add or change a record because a related record is required in
table 'tblcourse'.
I go to the frmCourse form and try to remove/change what I have in there,
but that form gives me the message:
The related record cannot be deleted or changed because table
'tblBannerRespondent2' includes related records.
The Data Entry is set to No and the Filter/Sort is off, but what else can I
do to get rid of these messages? I'm sure it's something I've done before
but I can't figure out what....
Thanks for all your help!
and trainer of all our training classes (frmCourse). I have another command
button linked to to another form (frmBannerRespondent2) where I enter
information applicable to the class itself (date, course number, respondent
number, trainer, Yes/No boxes, comments, etc.).
When I click on the command button linked to the Banner form, I can enter
the information, but if I go to change something I get the message:
You cannot add or change a record because a related record is required in
table 'tblcourse'.
I go to the frmCourse form and try to remove/change what I have in there,
but that form gives me the message:
The related record cannot be deleted or changed because table
'tblBannerRespondent2' includes related records.
The Data Entry is set to No and the Filter/Sort is off, but what else can I
do to get rid of these messages? I'm sure it's something I've done before
but I can't figure out what....
Thanks for all your help!