Re: [MSAccessProfessionals] DLookup not working

Porag,

It isn't clear to me what criteria you would use to filter Tbl_HBColor based on a value from Tbl_COTag and field from Tbl-HBColor.

UPDATE Tbl_COTag SET HB_Eng_Col = DLookup("ColourName","Tbl_HBColor","???")

Again, please include enough of the previous posts in your reply so that I don't have to scan through previous emails.

Duane

---

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

 

Dear Sir,

For your kind information, My requirement is from table "Tbl_HBColor", Field "ColourName" Text Data will populate  to Table "Tbl_COTag", in field "HB_Eng_Col" where lookup search value Table "Tbl_COTag" in field "COLOR" and entire this process will execute by update query. 

Thanks, 
Porag