Dlookup over two join tables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SharonInGa - 23 Nov 2005 02:22 GMT

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?

Reply to this Message

Allen Browne - 23 Nov 2005 02:58 GMT

Create a query into the 2 tables.

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> How do you code dlookup over two join tables?
>
[quoted text clipped - 7 lines]
> Can I use dlookup to retrieve data from the Inbound Table into a
> Form/Subform created off of the Outbound and Product Detail table?

Reply to this Message