<div>
I recommend to do a Public Function and use it in the SQL for the query<br />
<br />
Public Function get_imgpath()<br />
&nbsp; &nbsp; get_imgpath=DLookup(&quot;[Imag<wbr />eDirectory<wbr />]&quot;, &quot;tblDatabaseSetup&quot;)<br />
End Function
</div>


I recommend to do a Public Function and use it in the SQL for the query

Public Function get_imgpath()
    get_imgpath=DLookup("[ImageDirectory]", "tblDatabaseSetup")
End Function

<div>
Perfect as always. &nbsp;Thank you!
</div>


<div>
You are welcome. &nbsp;Glad I could help.
</div>


<div>
<div class="content wysiwyg-content">
I have a table with several records that have the following examples in a field named &quot;Image&quot;:<br />
<br />
B:\Dropbox\Business Documents\Database\Databas<wbr />e Images\Tree.jpg<br />
B:\Dropbox\Business Documents\Database\Databas<wbr />e Images\Football.jpg<br />
B:\Dropbox\Business Documents\Database\Databas<wbr />e Images\Rainbow.jpg<br />
B:\Dropbox\Business Documents\Database\Databas<wbr />e Images\Flower.jpg<br />
<br />
But I want to create an update query that will chance the text in the field to be a lookup from a table and the last part of the existing field value.<br />
<br />
So if the lookup value is...<br />
<br />
= DLookup(&quot;[ImageDirectory]&quot;<wbr />, &quot;tblDatabaseSetup&quot;)<br />
<br />
Then I want the new field values to read:<br />
<br />
The Looked Up Value\Tree.jpg<br />
The Looked Up Value\Football.jpg<br />
The Looked Up Value\Rainbow.jpg<br />
The Looked Up Value\Flower.jpg<br />
<br />
In other words the field should display the looked up value and keep the last part of the existing value for example Tree.jpg<br />
<br />
How can I create this update query?
</div>
</div>


I have a table with several records that have the following examples in a field named "Image":

B:\Dropbox\Business Documents\Database\Database Images\Tree.jpg
B:\Dropbox\Business Documents\Database\Database Images\Football.jpg
B:\Dropbox\Business Documents\Database\Database Images\Rainbow.jpg
B:\Dropbox\Business Documents\Database\Database Images\Flower.jpg

But I want to create an update query that will chance the text in the field to be a lookup from a table and the last part of the existing field value.

So if the lookup value is...

= DLookup("[ImageDirectory]", "tblDatabaseSetup")

Then I want the new field values to read:

The Looked Up Value\Tree.jpg
The Looked Up Value\Football.jpg
The Looked Up Value\Rainbow.jpg
The Looked Up Value\Flower.jpg

In other words the field should display the looked up value and keep the last part of the existing value for example Tree.jpg

How can I create this update query?

How design query to update field values in a table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.