Solved

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

Posted on 2011-10-01
3
294 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

770 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