Every time I try to update using frmCustomers, I get an error saying that the recordset is not updatable.
I don't understand why.
Advanced Beginner
Windows 7 64bit 
Access 2013
Every time I try to update using frmCustomers, I get an error saying that the recordset is not updatable.
I don't understand why.
VIP
Windows 7 64bit Access 2010 32bit
A form can enter/edit data to only one table. Including multiple tables that have a many relationship to another table makes the dataset not editable.
If you want to enter/edit data into tblCustomers and related tblCustomerEmail and tblCustomerPhoneNumbers, use form/subforms arrangement.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Form field to update two tables?
Posting Permissions
Reply With Quote