Solved

How to use the "DLOOKUP" function in a table and NOT a query?

Posted on 2011-10-01
3
295 Views
Last Modified: 2012-05-12
I can't find any examples of how to use the DLOOKUP function in a table to lookup text from values in another table.

The sample DB I created has two tables:
Table1
Table2

I am trying to pull the "Employee Training" field from Table 2 to Table 1, without using a query.

See example DB
DLookup.accdb
0
Comment
Question by:cssc1
3 Comments
 
LVL 33

Accepted Solution

by:
Norie earned 250 total points
ID: 36897221
You can't use any sort of calculation/lookup in a table.

If you have a form you can set the control source of, say, a textbox using DLookup.
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 250 total points
ID: 36897279
You will need to use a query or do this at the Form level.

mx
0
 

Author Closing Comment

by:cssc1
ID: 36897318
Thanks
0

Featured Post

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question