Forum Discussion
Need Assistance with access expression (DLOOKUP)
I am trying to look up a material description field in one table, and attempting to autopopulate in a form. The unique ID for both is the Material. I have build the following expression, but seem to be getting an error somewhere. Any thoughts?
=DLookUp("[Product Description]","Routing Information","[Material] = [Forms]![Production Entry]![Material]")
To correct the Dlookup expression, you need to put brackets around [Routing Information] since it includes a space (which is considered a special character). An alternative approach that may give you better performance would be to use a query for your form record source that joins to the [Routing Information] table to pull in the [Product Description]. The query should be updateable.
