Can't update table data from form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

Kelly,
Please do not multi-post. If you feel you must post the same question
to more than one newsgroup (and it's seldom necessary), cross-post by
adding each additional newsgroup in the To Newsgroups: box, separated
by a comma.
This way an answer in one newsgroup will be seen in each of the
others. More readers will see the response and learn, and less time
will be spent on duplicate answers.

See Netiquette at http://www.mvps.org/access

It's a great site to visit anyway.

To answer your question...
If the record source of the form is a table (not a multi-table query)
make sure:

1) Each control on the form is bound to a field in the table (Control
Source).

2) Check the Form Properties.
Allow Edits Yes
Allow Additions Yes
Allow Deletions Yes
Data Entry No

3) Check the properties of EACH control:
Enabled Yes
Locked No

If the Record Source of the Form is a multi-table query, open the
query and run it.
Is the New Record navigation button grayed out? If so, your query is
not updateable, therefore the form will not be updateable.
Check Access help regarding when a query is and is not updateable.
 
Back
Top