Access

Hi Hazel

Thank you for your question

The closest function is DLookup, D standing for domain.

It finds a value maching specified criteria in a specified field in a specified table. It can be used in a macro, query or calculated control on a form or report.

It has the following parameters.

expr - The field value you wish to return

Domain - The table containing the field

Criteria - An expression that limits the data to be returned

an example would look something like this

DLookup("[ProductName]", "Products", "[SupplierName] = John")


Hope this is helps

Regards

Stephen