[AccessD] field cannot be updated...

Hi,
I use a subform with a record source:

SELECT peoplefilms.aa, peoplefilms.IDperson, people.sex
FROM people INNER JOIN peoplefilms ON people.IDperson = 
peoplefilms.IDperson;

on peoplefilms.IDperson there is also a "not in list" event which works 
adding any new record on people

the problem is that after a "not in list"... I can't make any change on 
people.sex
have tried refresh or requery but nothing changes


thank's a lot

/kostas