InFlight
User
- Local time
- Today, 13:45
- Joined
- Jun 11, 2015
- Messages
- 130
I have 2 Tables Sections_New and Sections. Both have the same fields and data type.
I am trying to copy the data from the Judge field from Sections into Sections_New using the following code
the error is cannot find input table Sections_New.
the table Sections is a linked table and Sections_New is in the current DB
if i make a query using the code it works fine
I am trying to copy the data from the Judge field from Sections into Sections_New using the following code
the error is cannot find input table Sections_New.
the table Sections is a linked table and Sections_New is in the current DB
Code:
Dim strsql As String
strsql = "UPDATE Sections_New INNER JOIN Sections ON Sections_New.SectionID = Sections.SectionID SET Sections_New.Judge = [Sections]![Judge];"
db.Execute strsql
if i make a query using the code it works fine
Last edited: