Need Assistance with access expression (DLOOKUP)

Occasional Visitor

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]")

1 Reply

@jradstake 

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.