Re: [MSAccessProfessionals] DLookup not working

you can also create a function to Pick the correct color (see fnColor1 on Module1) and call the function on your

Update query (see Query2).

On Wed, Jun 21, 2023 at 4:27 AM Duane Hookom <duanehookom@hotmail.com> wrote:

I'm not sure if any file came through since I'm using my cell phone. 

You mention a query and DLookup but didn't provide the SQL view and data types of significant fields. This would be the minimum information required to get an accurate response. 

Duane

Sent from my mobile

On Jun 20, 2023, at 2:56 PM, porag379@gmail.com wrote:

Sir, Good evening. This is porag and I'm Microsoft Access learner. I want to use DLOOKUP in Access Table for pull data from difference Table but can't it. Could you help me?  Attached my Simple access database where I've created a update query with Dlookup function but not working. Could you point out my mistake?

Thanks
Porag

<TestData.accdb>

--

Arnelito G. Puzon

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116386) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_