DLookup function - search criteria x 2

[adamnorsworthy]

Hey there,

I would like to find a value from a record, and I am using the DLookup function. To find the right record I need to provide two references, the customer id and the booking id. I have tried to use 'And' such as:

dateineed = DLookup("[Arrival date]", "detbooking", "[BookingID]= " & refe.Value And "[CustomerID]= " & customer.Value)

with no luck. How can I get access the correct record in a record set when I can only specify the exact record if I have use two references?

Kind regards, Adam.

 

[rainman89]

This is a handy reference. looks like you are missing some things

http://www.mvps.org/access/general/gen0018.htm

 

[petehilljnr]

Because the criteria is a string, you have to include the AND inside the quotes:

e.g.

dateineed = DLookup("[Arrival date]", "detbooking", "[BookingID]= " & refe.Value & " And [CustomerID]= " & customer.Value)

Regards,
Pete