CODEWITHSUNDEEP
ms-accessdlookup
Nir4s
Nir4s

Reputation: 15

Getting value from query into subform using Dlookup

I wanna put value Allowed from query S_makers_list using Dlookup into textbox into subform C_products in HCPP form. I'm trying to use current maker value in subform as criteria

=DLookUp("[Allowed]";"S_makers_list";"[maker]= " & [me]![maker])

Instead of showing a value it displays #Name error in text box

Upvotes: 1

Views: 110

Answers (1)

Gustav
Gustav

Reputation: 55841

If maker is text, you need quotes:

=DLookUp("[Allowed]";"S_makers_list";"[maker]='" & [me]![maker] & "'")

Upvotes: 1

Related Questions