I am using VB6 to Modify records in related tables in MS Access. It will not accept because the table i am updating is related to another whose corresponding records i also need to modify.
How can i modify records in all the related tables?
This is the sample code am using;
Set rs2 = New ADODB.Recordset
rs2.Open "select * from PolicyDetails", cn, adOpenDynamic, adLockOptimistic
cn.Execute "update PolicyDetails set Pol_no = '" & Me.Text19.Text & "'where pol_no ='" & Pol_num & "'"
Table "policyDetails" is related to another, "Payments" and needs to be modified too. I will appreciate your help.
How can i modify records in all the related tables?
This is the sample code am using;
Set rs2 = New ADODB.Recordset
rs2.Open "select * from PolicyDetails", cn, adOpenDynamic, adLockOptimistic
cn.Execute "update PolicyDetails set Pol_no = '" & Me.Text19.Text & "'where pol_no ='" & Pol_num & "'"
Table "policyDetails" is related to another, "Payments" and needs to be modified too. I will appreciate your help.
