There is a DLookup (Domain Lookup) function in Access. However, that may
not be the best way to do what you want. It all depends on what you are
trying to do.
Access is NOT "Excel on steroids".
A database table is NOT A SPREADSHEET.
There is a DLookUp function which can be used in some circumstances, but odds
on there is a better way, using a Query to join two tables. Take a few hours
to get acquainted with what relational databases are, and how they work; if
you try to coerce Access into behaving just like the spreadsheets you're used
to, you will not be taking advantage of the features of the program. See:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.