Dlookup over two join tables?

[SharonInGa]

How do you code dlookup over two join tables?

Outbound Trucks Join Table Product Detail table Join Table Inbound
Table
- OB Truck ID Ob Truck ID PO# IN Truck ID
IB Truck ID
PO# PO#

Can I use dlookup to retrieve data from the Inbound Table into a
Form/Subform created off of the Outbound and Product Detail table?

 

[Allen Browne]

Create a query into the 2 tables.

Dlookup the query, i.e. use the query name as the middle argument of
DLookup().