auto create records

[June7]

Okay, should have realized that. But I don't use macros.

This works for me:

Private Sub tbxTask_AfterUpdate()
DoCmd.RunCommand acCmdSaveRecord


CurrentDb.Execute "INSERT INTO tblEvaluation (Task, Pupil) SELECT " & Me!TaskID & " AS TaskID, PupilID FROM tblPupil"
End Sub

[lockstock]

Ok i think i made it work! many thanks for your help and patience! ;-)