[RESOLVED] Associating a recordset field with a control in a SQL JOIN code

[osemollie]

Suppose I have a SQL JOIN code, how can I refer to the recordset fields when I want to associate some controls on the form with this code programmatically? Assume my code is

SELECT orderDetails.orderId,orderDetails.ProductId, orderDetails.UnitPrice, products.ProductName FROm orderDetails INNER JOIN products ON orderDetails.ProductId = products.ProductId

eg

txtName.text = rst!(field) what will the recordset field be?

Thanks