Home

Need Assistance with access expression (DLOOKUP)

%3CLINGO-SUB%20id%3D%22lingo-sub-401053%22%20slang%3D%22en-US%22%3ENeed%20Assistance%20with%20access%20expression%20(DLOOKUP)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401053%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20look%20up%20a%20material%20description%20field%20in%20one%20table%2C%20and%20attempting%20to%20autopopulate%20in%20a%20form.%26nbsp%3B%20The%20unique%20ID%20for%20both%20is%20the%20Material.%26nbsp%3B%20I%20have%20build%20the%20following%20expression%2C%20but%20seem%20to%20be%20getting%20an%20error%20somewhere.%26nbsp%3B%20Any%20thoughts%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3E%3DDLookUp(%22%5BProduct%20Description%5D%22%2C%22Routing%20Information%22%2C%22%5BMaterial%5D%20%3D%20%5BForms%5D!%5BProduction%20Entry%5D!%5BMaterial%5D%22)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401053%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-408713%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Assistance%20with%20access%20expression%20(DLOOKUP)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-408713%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F315093%22%20target%3D%22_blank%22%3E%40jradstake%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20correct%20the%20Dlookup%20expression%2C%20you%20need%20to%20put%20brackets%20around%20%5BRouting%20Information%5D%20since%20it%20includes%20a%20space%20(which%20is%20considered%20a%20special%20character).%26nbsp%3B%20An%20alternative%20approach%20that%20may%20give%20you%20better%20performance%20would%20be%20to%20use%20a%20query%20for%20your%20form%20record%20source%20that%20joins%20to%20the%26nbsp%3B%5BRouting%20Information%5D%20table%20to%20pull%20in%20the%20%5BProduct%20Description%5D.%26nbsp%3B%20The%20query%20should%20be%20updateable.%3C%2FP%3E%3C%2FLINGO-BODY%3E
jradstake
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies