Most chances are, whe you link few tables together you won't be allow to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6535
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
--
If I answered your question, please mark it as an answer. That way, it will
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6535
stay saved for a longer time, so other can benefit from it.
Good luck
"Kelly Wilbur" wrote:
> 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