[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

[noshaba]

it would be like
rst!("orderid") or rst!("productid") etc

[noshaba]

ur field name would be the same as u have in ur select list but u dont need to mention table name with field names

[osemollie]

Sorry I have to take you back on this. I thought I had this working but I have realised that the controls associated with this recordset are not displaying the required data. What could be the problem? Am using :-
txtPatron.Text = rst!("LastName")