[AccessD] field cannot be updated...

Can you make changes BEFORE you add a record? It smells like one of those
not update able query issue that happens when Access can't prove to itself
there could be one and only one record that reults from the join. Which
would be, if you joined on a key that is unique in both tables. Is IDPerson
unique in both tables?

If not, I would be surprised you could update existing records either,
whether the field be aa or sex.
On Mar 13, 2014 7:26 PM, "Kostas Konstantinidis" <kost36 at otenet.gr> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>