DLookup for two values

[mvtjd]

Is there a way to execute a Dlookup command based on two values?

The current command is:
Forms![frmUserEntry]![DefectDescription] = DLookup("[DefectDescription]", "Tbltotaltestdata", "[MeasurementName] = Forms![frmUserEntry]!MeasurementName&quot

The name of the field that I need to add is called CKPCode1. To clarify I need the lookup to be based on the two values of CKPCode1 and MeasurementName at the same time.

 

[JohnLowell]

You just need to build a lareger Where part of the Dlookup:

Forms![frmUserEntry]![DefectDescription] = DLookup("[DefectDescription]", "Tbltotaltestdata", "[MeasurementName] = '" & Forms![frmUserEntry]![MeasurementName] & "' and [CKPCode1] in ('X','Y')&quot

You also neede to have quotes around the Measurementname variable.