can't update form-in the bottom bar of

[ymds]

access i get a message that i can't update recordset object..

i didn't define nothing as recordset boject. why is it happen?
when i create a form with only one table fields i can update my form.


but when i add more fields from other tables i get that message and cannot update anything...

[NoellaG]

Hi,

as soon as a form shows some records, it has a recordset object bound to it. If you can't update the recordset, check the relations between the tables (for instance you can't update recordsets with outer joins) and if all necessary PK's are present in your sql expression or query.

kind regards,
NG

[NTC]

also - not all record sets are updateable (i.e. not all queries are updateable). Making sure the primary key exists in each table is one basic step. but doesn't guarantee the query to be updateable depending on the join.

if you are not able to make the query updateable; then reconsider attempting to bring all the data together in a single query and instead go to a Main/sub form concept - this usually works.