Hi, i want to make pass-trough quey in access with value from a textbox. Everything is ok except with part where i want to bring value from textbox.
How can i bring that value to query?
Thank you!
Code:
Update aa
SET
aa.x1 = ac.x1,
aa.x2 = ac.x2,
aa.x3 = ac.x3
from Table1 as aa
INNER JOIN Table2 as ac ON aa.y1 = ac.y1 AND aa.z1 = ac.z1
WHERE aa.w1 = '" & [Forms]![Form1]![w1] & "'
How can i bring that value to query?
Thank you!