Hello All
I have a continuous subform called ContractsReadSubform, that is based on a query called QueryContractsSubform.
One of the fields in the query is called CodeNo, which relates to the unique equipment number of a device. Every CodeNo has a serial number which is stored in the ImportEquipment table.
On the subform I want to be able to show the serial number of the CodeNo in an unbound text box. In the ImportEquipment table, the CodeNo field is called Code No with a space.
I have attempted this using the below example:
DLookUp("SerialNumber","ImportEquipment","Code No = " & Me![CodeNo]")
However the criteria that I am entering, always shows #Error in the unbound text box.
Can anybody spot where I am going wrong with this?
Thanks
I have a continuous subform called ContractsReadSubform, that is based on a query called QueryContractsSubform.
One of the fields in the query is called CodeNo, which relates to the unique equipment number of a device. Every CodeNo has a serial number which is stored in the ImportEquipment table.
On the subform I want to be able to show the serial number of the CodeNo in an unbound text box. In the ImportEquipment table, the CodeNo field is called Code No with a space.
I have attempted this using the below example:
DLookUp("SerialNumber","ImportEquipment","Code No = " & Me![CodeNo]")
However the criteria that I am entering, always shows #Error in the unbound text box.
Can anybody spot where I am going wrong with this?
Thanks