Re: [MSAccessProfessionals] DLookup not working

You would not want Tbl_HBColor in the query since it only needs to be referenced in the DLookup(). Also, the "domain" of the DLookup() is Tbl_HBColor but it doesn't contain the field "Color".

Could you describe your requirements in words? Also, when replying please include the previous thread so we have more context and don't have to search through deleted emails to find your original post and others.

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of porag379@gmail.com <porag379@gmail.com>
Sent: Wednesday, June 21, 2023 6:12 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] DLookup not working

 

Dear Sir,

Please see the below Snap and attached simple Database TestDB , where Tbl_COTag Table "COLOR" field value Lookup "ColourName" Field value from Table "Tbl_HBColor" and Lookup String (ShortText) value populate in field "Hb_Eng_Col" on Table "Tbl_COTag"  . Could you advise where I was mistaken ? Dlookup Not working on my TestDB which attached for your better understanding, your help and advise highly expecting.

Note : All are ShortText data