Free Lessons Courses Seminars TechHelp Fast Tips Templates Topic Index Forum ABCD

 Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon More... What's New? Popular Links ------------ Access Courses Access Index Access TechHelp Access Forum Access Troubleshooter Access Developer Network ------------ Excel Courses Excel Index ------------ Code Vault Testimonials Tip Jar Advice for Consultants

 Access    Excel    Word    Windows    HTML

# DLookup

## Using the DLOOKUP Function

In this tutorial you will learn how to use the DLOOKUP Function.

Take an example Table of Customers.

CustomerT
CustomerIDFirstNameLastNamePhoneCustomerSinceCreditLimitDaysGraceIsActive
1RichardRost716555777701/01/201210011True
2JoeSmith716555343401/03/19905005True
3SuzanJones562436514602/01/199815002False
4AlanWatson419389121217/05/2012503True
5AnnaPicore71323647905/05/200510204True
6RonaldSimms780746546804/04/1992502True
7DonaldBarker416441555501/03/19982505True
8BennySperduti716726726206/04/199916007False
9PeteSmith564559777704/04/20005003False
10BarbraPeters829282728831/12/2005501True
11JoeJones549546546601/06/20045003True
14PezzDispo26/09/201204True
16BobSmith04/10/201209True

In this example we have a CustomerID and we wish to find out their Firstname. So the Field we want is FirstName, the Domain is CustomerT and the Criteria is "CustomerID=1".

The DLOOKUP function returns a value from a specified set of records (or domain).

=DLOOKUP(Field, Domain, Criteria)

Query

The results using a Query would be

```	SELECT * FROM CustomerT WHERE CustomerID=1
```
tblNames
CustomerIDFirstNameLastNamePhoneCustomerSinceCreditLimitDaysGraceIsActive
1RichardRost716555777701/01/201210011True

FORM

In a Form you could set the Default Value of a Textbox to

```	=DLookup("*", "CustomerT", "CustomerID=1")
```
VBA

In a Form add a TEXTBOX control and rename it "txtDLookup", then you could add the following in the Load Event.

```	Private Sub Form_Load()
txtDLookup = DLookup("FirstName", "CustomerT", "CustomerID=1")
End Sub
```

Courses Tips

See this FREE Tip on DLOOKUP without Programming.

See this FREE Tip on DLOOKUP.

Search