Dlookup problems

[soupisgood84]

Is there something wrong with my code?
I keep getting the wrong value on this function. I get the value that comes next on my list.

=DLookUp("DepartmentName","tbl(dropdown)Departments","DepartmentNumber =" & "'" & [DepartmentNumber] & "'")

I also tried...

=DLookUp("DepartmentName","tbl(dropdown)Departments","DepartmentNumber =" & [DepartmentNumber])

 

[Remou]

Can you explain a little more? What do you mean by next value? Have you checked the value of DepartmentNumber?

 

[soupisgood84]

The value is fine.
I am trying to get my form to return a name opposed to a number. When the function returns a name it, for some odd reason, is the name of the next row on the table.

 

[Remou]

I have never seen this happen, so I cannot help, sorry.

 

[ck1999]

Have you tried replacing [departmentnumber] with a number to make sure if you used a constant that your expression is working.

example

=DLookUp("DepartmentName","tbl(dropdown)Departments","DepartmentNumber =2")

If this is working then you may want to isolate the value for deparmentnumber

ck1999

PS
Where do you have the above located and where is it pulling the value for the departmentnumber from

 

[genomon]

Have you tried =DLookUp("[DepartmentName]"..... ?

Did you hear about the Buddhist who refused Novocain during a root
canal? He wanted to transcend dental medication.