Search results

This worked. Also is the first piece of code I've written in Access.:)

This code gives a #Name? error message. KPI_Name field is a long text format KPI_ID is a an AutoNumber format

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] = " &...

Thank you. It's working perfectly now. I had it like how you suggested but I had [S_IDText] in quotes. I'm new to Access (2 weeks) and I'm still unsure where to add and avoid quotes.

<Solved> DLookup value does not show in Form View I have a database form in which there are two text boxes. The first one is S_IDText and the other is Text92. In the Text92 box I want to display the Source name that corresponds to the number present in the S_IDText. I'm doing this by using...