Is it possible to update two linked Access database fields using an ADODC control for each field?
I get a message informing me that I cannot change a record as a related record is required in another table. The code I am using is below. It works if the tables aren't linked, but that's not much use. I have tried hours to get this to work but to no avail.
REM Updates the first table
Adodc1.Recordset!A = Text3.Text
Adodc1.Recordset!As = Text4.Text
Adodc1.Recordset!BH = Text5.Text
Adodc1.Recordset!BB = Text6.Text
REM Updates the second table
Adodc2.Recordset!CN = Text30.Text
Adodc2.Recordset!F = Text31.Text
Adodc2.Recordset!S = Text32.Text
Adodc2.Recordset!De = Text33.Text