<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 nofollow">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.

are you referring to DLookup function?

there is no vlookup function in Access environment.

DLookup Function
https://support.office.com/en-us/article/dlookup-function-8896cb03-e31f-45d1-86db-bed10dca5937

I was wondering what alternative there are, maybe custom expressions or vba stuff.
yes, you can. but you need to evaluate if it&#39;s necessary to implement that.

Alternative of vlookup in Access 2016

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 &amp; returns that related info if found.

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.