>>>Take a look at
>>>
>>>SELECT-SQL command in Help.
>>Oh ohhh...you dont understand what i mean?
>
>
>ok ok if you have a table with three names how would you get them to show simultaneously in 3 text boxes

One last time.

select T1.Name as Name1, T2.Name as Name2, T3.Name as Name3 from Table T1, Table T2, Table T3 where T1.ID = 1 and T2.ID = 2 and T3.ID = 3

quick, though not very efficient way.