Trying To Add Data To A Filtered List

Ok access noob here and a first post as well...

I have to filter a table that has children and teachers.

I made a form with a combo box of teacher names then filtered
on the teacher name.
in the subform I have to create a matrix of the children that
are assigned to that teacher.

it would be something like this

teacher date child name start end


the teacher and child name are in tblmain

the date start and end values have to be in tbldata1

so the beginning they want to choose a teacher and a date
so I shifted and put the teacher in a combo box and tied it to nothing
but the subform
so combo box teacher and field date
links to subform are teacher;date

combo box(teacher name)==> Ms. Eve text box(date)==> 01/01/06

but they want a filtered list on teacher so the subform would have to be

teacher date child name start end
Ms. Eve 01/01/06 mary lamb
Ms. Eve 01/01/06 billy bull
Ms. Eve 01/01/06 bob jones


then they could put in start and end for each child

I don't see how I can get the child names filtered thru a query (this
I can do) BUT then to be able to edit the fields and put this data
into a new table.

IS there a way to do this?


a big help for any ideas or pointers as I am lost on this