Using Access 2013. I have two fields KPI_ID and KPI_Name in a table KPI.
I have a form where I've got the KPI_Name in a combo box. A text box is meant to display the KPI_ID of that KPI_Name.
I'm using DLookup on the text box which is:
=DLookUp("[KPI.KPI_ID]","[KPI]","[KPI.KPI_Name] = " &...