mpaulbattle
Registered User.
- Local time
- Today, 01:52
- Joined
- Nov 30, 2017
- Messages
- 56
Trying to write an expression that will give me the text value instead of the ID field on my form in a text box.
The form Record Source is based on a query of two tables: tblPractices and tblTechnical. what I am trying to get from the expression is the following
=IIf([Jobserver]<>"", "\\" & [Jobserver] & "\d$\eClinical\t8\" & [Mnemonic] & "\webapps\mobiled\jsp\catalog\lbs", "No Server")
\\ Jobserver1\d$\eClinical\t8\ABCD\webapps\mobiled\jsp\catalog\lbs...but this is not working and it puts in the box #type
However, if i use the id field it places the ID in there.
=IIf([JobserverID_FK]<>"", "\\" & [JobserverID_FK] & "\d$\eClinical\t8\" & [Mnemonic] & "\webapps\mobiled\jsp\catalog\lbs", "No Server")
\\1\d$\eClinical\t8\ABCD\webapps\mobiled\jsp\catalog\lbs...but this is not working.
This will be a hyperlink to open the folder.
Is it something I am missing?
The form Record Source is based on a query of two tables: tblPractices and tblTechnical. what I am trying to get from the expression is the following
=IIf([Jobserver]<>"", "\\" & [Jobserver] & "\d$\eClinical\t8\" & [Mnemonic] & "\webapps\mobiled\jsp\catalog\lbs", "No Server")
\\ Jobserver1\d$\eClinical\t8\ABCD\webapps\mobiled\jsp\catalog\lbs...but this is not working and it puts in the box #type
However, if i use the id field it places the ID in there.
=IIf([JobserverID_FK]<>"", "\\" & [JobserverID_FK] & "\d$\eClinical\t8\" & [Mnemonic] & "\webapps\mobiled\jsp\catalog\lbs", "No Server")
\\1\d$\eClinical\t8\ABCD\webapps\mobiled\jsp\catalog\lbs...but this is not working.
This will be a hyperlink to open the folder.
Is it something I am missing?