update in form view

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

Guest

Access will not let me update records using the form I have created. The
form consists of one form and two subforms. The associated tables are link
by a one-to-many relationship with cascading updates. The master and child
fields have been properly defined. What am I missing that is preventing me
from being able to update records in form view? Thanks for any assistance.
 
Check:

- The AllowEdits, AllowAdditions and AllowDeletions of both forms.
- If either of the forms is based on a query, the query may not be
updateable. The most common cause of this is including the primary key from
the one side of a one-to-many relationship. Include the corresponding
foreign key instead. To check if the query is updateable, open it and
attempt to change the data directly.

Sprinks
 
Back
Top