DLookUp, how to write?

[radek225]

I awlays have problem with this


"laczone" and "id_zlecenia_info" are text.

DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & '" And "[ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'")

code doesn't work. I think problem is

...And "[ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'")

 

[CJ_London]

"laczone" and "id_zlecenia_info" are text.

if that is the case, there is nothing wrong with your code so I suspect it is your data - is one of the form fields empty for example?

If not, please expand on 'code doesn't work' as at the moment it is not something that means anything

 

[CJ_London]

actually just spotted

...And "[ID_Zlecenia_info]='"

the double quote in red is not required

 

[radek225]

If not, please expand on 'code doesn't work' as at the moment it is not something that means anything

"Compile Error:
Expected: expression"

Dim czyjest As String


czyjest = DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & [COLOR="Red"]'[/COLOR]" And "[ID_Zlecenia_info]='" &  Me.NoweNumerZlecenia & "'")

If I have a code without this part

And "[ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'"

So code is

czyjest = DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & "'")

Then everything is ok

I know about Nz function, but there aren't empty fields.

 

[CJ_London]

the error description is telling you there is something wrong with your code - which I have answered in my second post

 

[radek225]

actually just spotted

the double quote in red is not required

So how should it looks like?

..And [ID_Zlecenia_info]='"

? Still doesn't work

 

[CJ_London]

same error?

Post the whole code

 

[radek225]

Ms Access Shows the line as red so something is wrong

Dim czyjest As String


czyjest = DLookup("[laczone]", "tblZlecenia", "[Laczone]='" & Forms![frmZlecenieRoboczeMarzena]![ID_Zlecenia] & '" And [ID_Zlecenia_info]='" & Me.NoweNumerZlecenia & "'")

 

[CJ_London]

this

...![ID_Zlecenia] & '" And ...

should be

...![ID_Zlecenia] & "' And ...