Updating records from the form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TLuebke - 31 Oct 2005 16:06 GMT

I have a form based on two joined tables. tblStudentClassInfo and
tblServicesNeeded. I link the tables on two fields, StudentID and CourseID.
tblServicesNeeded has no data.

The form is populated with info from tblStudentClassInfo and has a series of
checkboxes that need to be stored in tblServicesNeeded. When I test the form
and select check boxes they show up on tblServicesNeeded but the StudentID
and CourseID are empty. I need them to fill with the appropriate StudentID
and CourseID so I can use them in other queries.

Q - How do I coded my form to write the StudentID and CourseID into the
empty fields along with the selected checkboxes in tblServicesNeeded?

Reply to this Message

Bob Miller - 31 Oct 2005 21:17 GMT

Sounds like a job for subform man!
Create one form based on the tblStudentClassInfo and another based on
tblServiceNeeded. Place the second (sub)form in the first and link
Parent StudentID and CourseID to the same Child fields. This is a
property of the subform. When you check the boxes in the subform the
two IDs should populate the second table.
TLuebke Wrote:

> I have a form based on two joined tables. tblStudentClassInfo and
> tblServicesNeeded. I link the tables on two fields, StudentID and
[quoted text clipped - 14 lines]
> the
> empty fields along with the selected checkboxes in tblServicesNeeded?

Signature

Bob Miller

Reply to this Message