Why can 't i update? I have 2 identical tables school1 and school. The school1 is imported table and i want
that the field student be updated from the field student1 and be equalt to student1.The code shows no error,
but no update is carried out either, and the data in the field student remain unchanged.
May i ask where is the fault ?
Dim StrClass As String
StrClass = " UPDATE school INNER JOIN school1 ON school.productid=school1.productid SET " & _
" school1.student1 = school.student"
CurrentDb.Execute StrClass
End Function
that the field student be updated from the field student1 and be equalt to student1.The code shows no error,
but no update is carried out either, and the data in the field student remain unchanged.
May i ask where is the fault ?
Dim StrClass As String
StrClass = " UPDATE school INNER JOIN school1 ON school.productid=school1.productid SET " & _
" school1.student1 = school.student"
CurrentDb.Execute StrClass
End Function