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

visual basic code: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

Because all of the fields in the result set have unique names—that is, you don't have something like:
SELECT orderDetails.ID,
       orderDetails.orderId,
       orderDetails.ProductId,
       orderDetails.UnitPrice,
           products.ProductName,
           products.ID
FROM orderDetails
INNER JOIN products
        ON orderDetails.ProductId = products.ProductId
—you can simply use the field name:

I have tried that but nothing is displayed in the textbox and i dont get any error. I don't know where am going wrong.

I have tried the code and works well on normal form but not in a TabStrip contol. I have these text boxes inside a frame and this frame is one of the tabs on a tabstrip control. could it be that there is a special way of referencing these textboxes in a tabstrip environment? For trial sake, I have tried this code inside a form's load event but nothing appears in the textboxes.

Sorted out! It was something to do with my program flow. Thanks for your help.