arnelgp
..forever waiting... waiting for jellybean!
- Local time
- Today, 18:36
- Joined
- May 7, 2009
- Messages
- 19,169
If you can't get it work with Dlookup(), Listen to other suggestions.
Use a Query for your subform's Recordsource.
Join Product table and Division table with your Quotation detail table.
Query1:
use the Query as Recordsource of your subform.
Use a Query for your subform's Recordsource.
Join Product table and Division table with your Quotation detail table.
Query1:
Code:
SELECT [Quote Detail].*,
Divisions.[Division Name],
Products.[Product Name]
FROM ([Quote Detail]
LEFT JOIN Divisions ON [Quote Detail].DivisionID = Divisions.DivisionID)
LEFT JOIN Products ON [Quote Detail].ProductID = Products.ProductID;
use the Query as Recordsource of your subform.