Dlookup Criteria

[LOIZOS]

Hi
I am using the following statement and I am not getting the correct information
=DLookUp("Katanalosi";"TBL_KATANALOSI";"Customer_C ode=" & "Code" And "Paroxi=" & [counter])

The problem is my criteria.
It seems that the AND is not working

[Customer_Code] (NUMBER)
[Paroxi] (Short Text)
are primary and Secondary keys in TBL_KATANALOSI table




Pls help

Thanks

Loizos

[Bob Fitz]

Maybe:
=DLookUp("Katanalosi";"TBL_KATANALOSI";"Customer_C ode=" & Me.Code & " And Paroxi='" & [counter] & "'")

EDIT:
The space in:
"Customer_C ode=

should not be there but for some reason I can not remove it

[pbaldy]

The space in:
"Customer_C ode=

should not be there but for some reason I can not remove it

The forum software does that sometimes. Code tags will avoid it.

[Bob Fitz]

The forum software does that sometimes. Code tags will avoid it.

Thanks for the advice Paul.
A good reason for using the tags at all times, even if it is only one line.

[pbaldy]

It seems like if there are X number of characters without a space, the forum forces one. It's a feature, not a bug.

[LOIZOS]

Thanks Bob

Is not working. I am getting an #error

[Bob Fitz]

Where are you using the expression

[LOIZOS]

I am using the expression in a form.
I changed the expression
=DLookUp("[Katanalosi]";"TBL_KATANALOSI";"[Paroxi]='01.03'" & " And [Customer_code]=227")
and I am getting the correct ingormation but when I changed to the following I am getting a null value why??
=DLookUp("[Katanalosi]";"TBL_KATANALOSI";"[Paroxi]='Counter'" & " And [Customer_code]=[code]")

[andy49]

"([paroxi]='" & counter & "' and [customer_code] = " & code &")"

For the where part?