Solved

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

Posted on 2011-10-01
3
292 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 - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) 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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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 a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now