DMax with two variables 1

[Eprice]

Hi,
I cant get the correct syntax to use two variables in my code. I keep getting you canceled the previous operation!
With one variable i have:
Dim MyNum, MyState, MyLob
MyState = "AL"
MyLob = "CA"
MyNum = DMax("[AutoNo]", "tblMinRate", "[State] = " & "'AL'")
MsgBox MyNum
How do I add MyLob at the end of this? I have tried several ways and can't find anything in search for two variables.
Thanks
Lisa

 

[Remou]

It is a Where staement, without the word Where so:

[tt]DMax("[AutoNo]", "tblMinRate", "[State] = '" & MyState & "' And Lob='" & MyLob & "'")[/tt]

 

[Eprice]

That works! I was trying to put " before Lob and that must have been giving me the error. Thanks