We help IT Professionals succeed at work.

Alternative of vlookup in Access 2016

Gilberto Sanches
Gilberto Sanches used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Ryan ChongSoftware Team Lead

Commented:
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
Freelance ICT Consultant
Commented:
Yeah, I also found the Dlookup. Didn't got it working.

Yeah, I was wondering what alternative there are, maybe custom expressions or vba stuff.
Ryan ChongSoftware Team Lead

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