recordset is non updateable

[tails]

How come my form wont allow me to update it. i have many tables and queries and i have set it up for dataentry, but it wont allow me to enter data into it... does anyone know how to fix this. i have to get this done ASAP and your help would be greately appreciated.

 

[SydneyGeek]

If the recordset is too complex -- esp. if it is based on many-to-many links -- you may find it isn't updateable.
Not sure without seeing the layout, but a re-design of the query will probably be required.

Denis

 

[tails]

Thanks for that but i dont actually have a query set up to that particular form, just 2 tables with a relationship of the 'employee number' field. Should i use sub forms instead of using the main form for all the data?

 

[SydneyGeek]

Access is fussy about which field you choose, if you want the recordset to be updateable.
You'll need to have the primary key of the main table in the query list, even if you don't display it in the form. Also, say you picked [Employee No] from Table 1. Try picking it from Table 2 instead.
(A bit of hand-waving, without seeing the dataset -- but you'll see what I mean )

Note: By "Main Table", I mean the table that has the majority of fields -- usually the one the form is named after. To be updateable, the fields on the layout need to come from this table where you have a choice. Only pull in related fields that don't appear in the main table.

Denis

 

[tails]

Thanks man that helped heaps. You truely are unbelievable. I dont know how you know so much about access, but as long as you keep the info comming my way i'm happy. thanks a heap. ray:

 

[SydneyGeek]

No worries

Denis