DLookup Function Example
This example returns name information from the Company Name field of the record satisfying the criteria. The domain is the Shippers table. The criteria argument restricts the data by making the expression apply only to the record in which Shipper ID equals 1.
X = DLookup("[Company Name]", "Shippers", "[Shipper ID] = 1")