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?
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.