Access Form update

[oli insight]

Hello there,

I have found that i cannot update a record via a form if the form has fields from several different tables .... But it works fine if the a the field in the form come from a single table...

Can anyone help ?

[pks00]

I take it your form is based on a query

A query is not updateable due to a number of reasons, some of them being

1. u are using aggregate functions
2. records returned are not uniquely identifable
3. u may be using union

how is your query setup?

[oli insight]

I take it your form is based on a query

A query is not updateable due to a number of reasons, some of them being

1. u are using aggregate functions
2. records returned are not uniquely identifable
3. u may be using union

how is your query setup?

Hello mate,

Well actually, as far as i can see, no.. I know I can include a query in a form but have not done so.. But its strange because when i following online advice and "menu walk throughs" sometimes things work and sometime not when i'm clearly doing things the right way...
like allow data entry yes/no, allow edits yes/no, allow additions yes/no ....
in form > design view > properties

As for my queries, the way i'v set it up is by putting all the fields i have into a query and then simply changing the criterias every time i want to make a different search... It kinda avoids having to build a different query each time.