I've worked out what you mean by the container I think and have changed the subform name in the properties so it now has Name: ctrFacultyEvent and source object sfrmFacultyEvent the query runs but now it doesn't update the table with the FacultyID although the rest of the query works. I now have:
Code:
INSERT INTO tblFacultyEvent ( FacultyID, EventID, EventStartDate, EventEndDate )
VALUES (Forms!frmEvent!ctrFacultyEvent.Form!cmboFaculty, [Forms]![frmEvent]![EventID], [Forms]![frmEvent].[EventStartDay], [Forms]![frmEvent]![EventEndDate]);
I'm thinking maybe I need to change it to
Code:
INSERT INTO tblFacultyEvent ( FacultyID, EventID, EventStartDate, EventEndDate )
VALUES (Forms!frmEvent!ctrFacultyEvent.sfrmFacultyEvent!cmboFaculty, [Forms]![frmEvent]![EventID], [Forms]![frmEvent].[EventStartDay], [Forms]![frmEvent]![EventEndDate]);
But I'm not sure that will work either as the Query runs from the subform not the main form.