Editing data in a form that is linked to multiple source tables

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

Guest

I've created a form in a database that pulls information from multiple
tables. I'm now trying to set the properties in the form to allow the user to
edit data in the fields on the form, which would then cause the field in the
corresponding table to be changed. For the life of me, I can't get this to
work. I believe it is because I'm linking multiple tables together for the
source of the form, so it's not allowing any changes to the data; however, my
Access is a little rusty, so I'm not sure that this is the cause, and I don't
know how to fix it if it is. I'd like for this form to allow changes to the
data, then I plan on creating another form to allow the user to add a new
record, which would add the data to all of the corresponding fields in all of
the tables.

Any help will be greatly appreciated. Thanks.
 
I don't know about multiple table on the same form but whenever you have a
form based on a query of multiple tables you have to set the RecordsetType
form property to Dynaset (Inconsistent Updates)
 
Back
Top