Visual Basic DLookup returns null

[michelle]

What have I missed in this question?

The variables highestBoxId and travel are declared.
The database in Access is called Photos and it contains the columns eg.
boxId and travelname
which I know contains data. The table consists of 4 rows whith 4
travelnames so it
can not be moore than 1 hit.

Still, after executing this row, highestBoxId, is null. WHY?

highestBoxId = DLookup("max(boxId)", "Photos", "[travelname] = travel")

I appreciate all help
/Michelle

(e-mail address removed)

 

[Tom Lake]

highestBoxId = DLookup("max(boxId)", "Photos", "[travelname] = travel")

If the field in the Photos table is called boxId then you have to do this:

highestBoxId = DLookup("[boxId]", "Photos", "[travelname] = travel")

Tom Lake

 

[Douglas J Steele]

If you want the maximum, use DMax, not DLookup.

As well, if you're looking for the literal word travel as the value for
travelname, you need to put quotes around it since it's text:

highestBoxId = DMax("boxId", "Photos", "[travelname] = 'travel'")

If travel is the name of a variable that holds the value you want to check,
it needs to be outside of the string (but its value needs to be in quotes):

highestBoxId = DMax("boxId", "Photos", "[travelname] = '" & travel & "'")

Exagerated for clarity, that's

highestBoxId = DMax("boxId", "Photos", "[travelname] = ' " & travel & " ' ")

 

[michelle]

Thanks! Great!

You made my day, no my week.

;-)
Michelle