Combine Update Query with a Dlookup?

[Endlessknight]

Greetings All,

I have two tables, Table1 and Table2. Table 1 is a key with two fields, Field1 and Field2, Field1 uniquely determines Field2. Table 2 has the same two fields, and a few others, but often it has an incorrect value in Field2.

What I would like to do is make an update query on Table 2, it takes the value in Table2.Field1 and looks it up in Table1 and returns the value in Table1.Field2 and updates Table2.Field2 to that value.

Not sure if this is possible but I tried to make an update query using table2. In "update to" under field2 I entered DLookUp([Field2],[Table1],[Table2].[Field1]). When I try to run it I get a msgbox asking to enter a parameter value for Table1.

I'm sorry I know that's a convoluted description but any help would be greatly appreciated.

Thanks

 

[stumac]

Using Dlookup would be an inefficient way of doing this, join the tables in the query:

UPDATE Table1 INNER JOIN Table2 ON Table1.Field1 = Table2.Field1 SET Table2.Field2 = [Table1].[Field2]

if you want to use Dlookup then the expression you are updating to would be:

DLookUp("[Field2]","Table1","Field1 = " & [Field1])

 

[Endlessknight]

Using Dlookup would be an inefficient way of doing this, join the tables in the query:

UPDATE Table1 INNER JOIN Table2 ON Table1.Field1 = Table2.Field1 SET Table2.Field2 = [Table1].[Field2]

That worked perfectly!

Thank you so much.