<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
=DLookUp("[S_Name]","[Sources]","[S_IDText].[Text]=" & "[Sources].[S_ID]")
Sources is the table name.
S_Name is a text field that is the Source Name inside the Sources table.
S_ID is a number field that is a unique number for each source.
The form basically scrolls through KPI names and their S_ID. So whenever the S_ID is displayed, I want Text92 to display the source name. The form record source is the KPI table.
The issue is that in Layout view Text92 shows the S_Name no problem. But in Form View it shows up blank and tweaking the code around gives me #Type! or #Name! errors.
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
=DLookUp("[S_Name]","[Sources]","[S_IDText].[Text]=" & "[Sources].[S_ID]")
Sources is the table name.
S_Name is a text field that is the Source Name inside the Sources table.
S_ID is a number field that is a unique number for each source.
The form basically scrolls through KPI names and their S_ID. So whenever the S_ID is displayed, I want Text92 to display the source name. The form record source is the KPI table.
The issue is that in Layout view Text92 shows the S_Name no problem. But in Form View it shows up blank and tweaking the code around gives me #Type! or #Name! errors.
Last edited: