adding a record into a sub-form

[Richard Hollenbeck]

I'm getting errors. Access is telling me that it can't add a record. I
have a table of college courses and a linked table of groups of activities
in that course as a linked table (one course to many groups of activities).
"Groups" include things like Participation, Exams, Essays, Etc., Etc., Etc.
I have a main form showing the course information (courseID,
courseDescription, courseStartDate courseEndDate, etc.) and a sub-form
showing the individual groups within that particular course. The sub-form
doesn't show the courseID because it's obvious; it's the current course in
the main form.

How do I send the courseID of the current course into the group table's
corresponding field? VBA? I don't know how to do that. I have the
relationship property set to "enforce referential integrity" and both
"cascade update" and "cascade delete" Shouldn't that be enough? Maybe I'm
doing something else wrong?

[Peter Russell]

Richard Hollenbeck previously wrote:

I'm getting errors. Access is telling me that it can't add a record.
To what - the main form or the subform? (I'm assuming it's the subform)
What is the message and when do you get it?
I
have a table of college courses and a linked table of groups of
activities
in that course as a linked table (one course to many groups of
activities).
"Groups" include things like Participation, Exams, Essays, Etc., Etc.,
Etc.
I have a main form showing the course information (courseID,
courseDescription, courseStartDate courseEndDate, etc.) and a sub-form
showing the individual groups within that particular course. The
sub-form
doesn't show the courseID because it's obvious; it's the current course
in the main form.

How do I send the courseID of the current course into the group table's
corresponding field?

If the subform is based on a table or a simple query of that table then as
long as the mainform-subform link is correct this should be ok. The
courseid value should be entered automatically.

If this is not working then look at the form subform links to be sure you
are using the courseid as the master and child link field.
Another possibility is that the query for the subform is too complex and
is not updateable. If you run the query on its own can you add/edit
records?

Other less likely possibilities are that the subform is set to
AllowAdditions = No (you would not be able to go to a new record) or that
the subform control is locked (you could get to new record but not enter
anything)

Peter Russell