<div>
are you referring to <b>DLookup </b>function?<br />
<br />
there is no vlookup function in Access environment.<br />
<br />
DLookup Function<br />
<a href="https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937" rel="ugc">https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937</a>
</div>


Freelance ICT Consultant

Gilberto Sanches

<div>
<blockquote>
I was wondering what alternative there are, maybe custom expressions or vba stuff.
</blockquote>
yes, you can. but you need to evaluate if it's necessary to implement that.
</div>


<div>
<div class="content wysiwyg-content">
What options are there to have something like a vlookup in Access 2016 database?<br />
<br />
So when we insert a record, another field takes that info automatically, searches for something related to it &amp;&nbsp;returns that related info if found.
</div>
</div>


What options are there to have something like a vlookup in Access 2016 database?

So when we insert a record, another field takes that info automatically, searches for something related to it & returns that related info if found.

Alternative of vlookup in Access 2016

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.