dlookup in access?

ashleywanless

Board Regular
Joined
Aug 4, 2009
Messages
158
Hi i have two tables, firstly business area tbl contains an ID, description and email field, secondly initiatives table holds business area description and business email. When the user enters the business area description from the dropdown lookup in the initiatives input form i want the email field to pre populate based on the email in the business area table email field.

Can this be done on my tables or only on my form?

Thanks
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,098,859
Messages
5,465,111
Members
406,412
Latest member
superjoejoe

This Week's Hot Topics

Top