Using textbox to update another text box in MS Access

Question

I am trying to update a textbox#2 based on the value in Textbox#1. The value in the textbox#1 is taken from from a string using " Mid([ScantheCode],1,10)" from ScantheCode box. I have tried couple of things but I am getting #error or #name.

I am using

=(DLookUp("ProductName","List","ProductN=" & [Textbox#1] & "'"))

Please help me find the solution for it.

Thank you, regards, Rohan

score 0 · Answer 1 · answered Jul 04 '22 at 14:02

0

ProductN is probably text, so try inserting the missing quote:

=DLookUp("ProductName","List","ProductN = '" & [Textbox#1] & "'")

answered Jul 04 '22 at 14:02

Gustav

53,498
7
29
55

Hi Gustav, Thank you for the help. It is working. But if I use this with afterupdate or onchange. It does not work any idea on this? – rohan n Jul 04 '22 at 14:31
You may need to requery the textbox. – Gustav Jul 04 '22 at 14:35

Using textbox to update another text box in MS Access

1 Answers1