How do you update data in a field, when the form(containing the field) was based upon a query?
I have many fields, half of them are for display purposes only, the other half need to be updated.
As long as the query that the form is based on is updateable, you can just type into the form fields and the data will be saved to the underlying table(s). Tables and queries are interchangeable for most purposes.
Got it sorted. It appears that access will only allow you to update data in a query if there are no more than 1 one-to-many relationships - my query had 5.
This is proberbly down to bad programming skills, however i am not responsible for the design. I am the 4th person in my company to try and crack this one.
I've done more than one one-to-many relationship in a query, however if you try to use any of the Domain level functions in your query, the recordset will end up non-updateable.
Look up in Access help: 'when can I update data from query' for more information.