recordset won't update

[charlieb]

I made a query using 2 tables and a lot of equations. It is the record source for my form. When I run it the form is read only and I cant change the fields or move to a new record. What is the problem and how can I get around it?

[ranman256]

Is the form set to updatable?
is the query in the form set to dynaset?
sometimes joining 2 tables make it impossible to update. Just update 1 unjointed.

[ssanfu]

Not a whole lot of info provided, but you might think about using a main form/sub form arraignment.

[CJ_London]

I agree with other posters comments - calculated values in a query wont be updateable and if you think about an update - how does access 'know' which table to update?

Depending on your query and form, you could try changing the form recordset type to dynaset - inconsistent updates. You may also need to move some of your calculated values to unbound controls on your form for this to work. If that doesn't work and you need to keep the recordsource to two tables and lots of calcs, your only other recourse is to use an unbound form - google 'access unbound forms' for more information