J
Jody
I am new to Access. I am trying to autofill a form using DLookup. I am not
getting any output from the function once I set the condition that should
autofill. here is what I have:
2 tables...1 with ProductNameVendor1 and Size and another with PONumber, PR
Number, ProductNameVendor1.
On my form, I have a drop down menu for the Product Name. Once it is
entered, I want the container Size to fill. Here is the DLookup I am using:
=DLookUp("SizeVWR","VWR Chemicals","ProductNameVWR = ' " & [ProductNameVWR]
& "'")
Size is text that is why I am using the double " marks. Any ideas on what I
am doing wrong?
Thanks, Jody
getting any output from the function once I set the condition that should
autofill. here is what I have:
2 tables...1 with ProductNameVendor1 and Size and another with PONumber, PR
Number, ProductNameVendor1.
On my form, I have a drop down menu for the Product Name. Once it is
entered, I want the container Size to fill. Here is the DLookup I am using:
=DLookUp("SizeVWR","VWR Chemicals","ProductNameVWR = ' " & [ProductNameVWR]
& "'")
Size is text that is why I am using the double " marks. Any ideas on what I
am doing wrong?
Thanks, Jody