Solved dLOOKUP

[sbaud2003]

Me.TXTUC.value = DLookup([Unit Code], "UNIT", "[unitid] = '" & CMP001 & "'")
I am using the above codes to get the [Unit Code] where unitid is a string character "CMP001" but flases error

 

[Gasman]

If that is a value and not a variable? then just hard code it.?

 

[Deleted member 147267]

I couldn't see the error message and number from here....
But I'll take a guess - you have no quotes around your field name.
"[Unit Code]"

 

[theDBguy]

Hi. I think you also need to put the field name in quotes.

Edit: Ugh, too slow...

 

[June7]

Put together:

Me.TXTUC = DLookup("[Unit Code]", "UNIT", "[unitid] = 'CMP001'")

If you want unitid parameter to be dynamic, reference control that contains value:

Me.TXTUC = DLookup("[Unit Code], "UNIT", "[unitid] = '" & Me.tbxUID & "'")

Why do you need to save Unit Code if you have UnitID in record? Retrieve Unit Code in query joining tables.

Advise not to use spaces in naming convention.

 

[sbaud2003]

Thank you very Much... Now I got it
This forum is wonderful...
Have a safe day