DLookup with two criteria

[craig1988]

Hi All



I cannot for the life of me get the end of the statement to work!!!

In the criteria field of the below DLookup I want to Look up an "EndSerialNo" from the "tblOrderHistory" where The AccNo is the same as Me.AccNo AND the Style is the same as Me.txtStyle

I must have the syntax wrong but I am tired and grumpy and have had to look for help!!

SSer = Nz(DLookup("EndSerialNo", "tblOrderHistory", "AccNo='" & Me.AccNo.Value "'" And "Style='" & Me.txtStyle.Value & "'")

[orange]

SSer = Nz(DLookup("EndSerialNo", "tblOrderHistory", "AccNo='" &  Me.AccNo.Value "'" And "Style='" & Me.txtStyle.Value & "'")

You don't have matching brackets.

I think this is what I'd try (untested)

SSer = Nz(DLookup("EndSerialNo", "tblOrderHistory", "AccNo='"  &    Me.AccNo  & "'  And  Style='" & Me.txtStyle & "'"),0)