Can't change table data from a form

[Kelly Wilbur]

I have created a very simple form that pulls information from a number of
tables (the form is built on tables, not queries). I try to update my
information while I am in a form, but the form doesn't allow me to type in
any fields or change any values in any fields. However, I can change the
values if I go straight to the table.

How can I set this up to be able to use the form to update data in the tables?

I was once told (perhaps incorrectly) that I needed to have the form built
from queries which were built from tables in order to be able to update from
a form. However, I tried this and had the same problem.

Please help.

Thanks,

Kelly

 

[Ofer]

Most chances are, whe you link few tables together you won't be allow to
update them, you can update each oe seperatly, but when you join them
together you can't.

In the form, you can try and split the tables to seperate sub forms ,that
each one of them based on another table.

Try and update the query or the sql that the form is based on, if you can,
then check the can edit ptoperty of the form if it set to yes