Dlookup with Multiple Criteria question

[papic1972]

Hi,

I'm having a tough time getting the following Dlookup to work:

DLookup("[ConfirmedLoad]=0", "qryDriver4a2", "DeliveryDate=#" & Format(Forms!frmLoadAllocation!cboAllocationDate.Value, "mm/dd/yyyy") & "#" & "AND [StateID]='1'")

My original Dlookup (which worked fine!) didn't require StateID but it is necessary to include it now. Can anyone help me with the correct syntax for the StateID portion? Thank you.

 

[papic1972]

Apologies for my brain explosion, i've worked out a better method, this works if anyone else needs it!

DLookup("[ConfirmedLoad]=0", "qryDriver4a2", "[StateID]=" & Forms!frmLoadAllocation!txtState & " And DeliveryDate=#" & Format(Forms!frmLoadAllocation!cboAllocationDate.Value, "mm/dd/yyyy") & "#")

Have a great day!

 

[narang]

Hello,

You could try

DLookup("[ConfirmedLoad]", "[qryDriver4a2]", "[DeliveryDate]=datevalue('" & Me.Controls("cboAllocationDate").Value & "') and [StateID]='" & Trim(Nz(Me.Controls("txtState").Value)) & "'")

Rgds

 

[papic1972]

Hi Pat Hartman,

Why are saying that DLookup("[ConfirmedLoad]=0" can't be right? It works fine.