Needing help with Expression to return Text value instead of ID

[mpaulbattle]

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\js p\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\catal og\lbs...but this is not working.

This will be a hyperlink to open the folder.

Is it something I am missing?

[June7]

Is JobserverID_FK a number type field? If so, testing for empty string is meaningless.

Why is form bound to query of two tables?

Which table has Jobserver and JobserverID_FK fields?

If you want to provide db for analysis, follow instructions at bottom of my post.

[orange]

It would be helpful if you could
-show readers the table designs (field names and datatypes),
-provide plain English description and sample of what you want to achieve.

[Bob Fitz]

Cross Posted: https://www.access-programmers.co.uk...f-text.312939/


mpaulbattle
Please read: https://www.excelguru.ca/content.php?184

[mpaulbattle]

Is JobserverID_FK a number type field? If so, testing for empty string is meaningless.

Why is form bound to query of two tables?

Which table has Jobserver and JobserverID_FK fields?

If you want to provide db for analysis, follow instructions at bottom of my post.

The form is bound by a query of two tables because I need [Mnemonic] from tblPractices and the [Jobserver] from tblHSJobServer

Breakdown of the tables: (I threw in a third table because that is where the JobServer is located.) I did add the 3rd table to my query before posting this reply but still the same message.
tblPractices | tblHostingServices | tblHSJobserver
PracticeID HostingServiceID JobServerID
Mnemonic PracticeID_FK JobServer
JobServerID_FK

I will try to provide a db but can't from my work computer. Won't allow me to.

[mpaulbattle]

Cross Posted: https://www.access-programmers.co.uk...f-text.312939/


mpaulbattle
Please read: https://www.excelguru.ca/content.php?184

thanks for the reminder.

[mpaulbattle]

Ok, so somehow the change i made took place after logging out and back in
It seems to be working.
Took the que from which table is JobServer listed under