I have:
DLCH1: DLookUp("[parent_equipment_item_id]","[Data]","[unique_id] ='" & [parent_equipment_item_id] & "'")
This works as the ID's are numbers
and want to add:
[Equip Lin]="XXB840"
it is a string
DLCH1: DLookUp("[parent_equipment_item_id]","[Data]","[unique_id] ='" & [parent_equipment_item_id] & "' AND [Equip Lin]=XXB840") = #Error
I know it has to do with the " and '