DLookup will only return a Null

[gchichester via AccessMonster.com]

Can anyone see why this DLookup will only return a Null?
I have verified that all data types are set to Text, and
the lookup table has the correct data.

? Forms![frmAsiaNotice]! [AsiaNoticeShipLine]
FE NYK Lines

? Forms![frmAsiaNotice]! [cboAsiaNoticeServiceContractCustomer]
SUMIFRU CORPORATION

? DLookup("[ContractNumber]", "AsiaContract", " [ContractShipLine] = '" &
Forms![frmAsiaNotice]![cboAsiaNoticeShipLine] & " And [Contract]!
[ContractCustomer] = " _
& Forms![frmAsiaNotice]![cboAsiaNoticeServiceContractCustomer] & "'")
Null

 

[Ken Snell]

You're missing some ' characters:

DLookup("[ContractNumber]", "AsiaContract", " [ContractShipLine] = '" &
Forms![frmAsiaNotice]![cboAsiaNoticeShipLine] & "' And [Contract]!
[ContractCustomer] = '" _
& Forms![frmAsiaNotice]![cboAsiaNoticeServiceContractCustomer] & "'")

 

[gchichester via AccessMonster.com]

Ken,
Thanks, for the fast responds, DLookup is working as expected.

You're missing some ' characters:

DLookup("[ContractNumber]", "AsiaContract", " [ContractShipLine] = '" &
Forms![frmAsiaNotice]![cboAsiaNoticeShipLine] & "' And [Contract]!
[ContractCustomer] = '" _
& Forms![frmAsiaNotice]![cboAsiaNoticeServiceContractCustomer] & "'")

Can anyone see why this DLookup will only return a Null?
I have verified that all data types are set to Text, and

[quoted text clipped - 11 lines]

& Forms![frmAsiaNotice]![cboAsiaNoticeServiceContractCustomer] & "'")
Null