>>>>>
>>>>>ok so is ID like the number of the table?
>>>>
>>>>Sorry, I haven't looked at the whole thread. My assumption is that Naomi expects the table to look like this:

CREATE TABLE Test (ID int, Name C(20))
>>>>INSERT INTO Test (Id,Name) VALUES(1,"Tom")
>>>>INSERT INTO Test (Id,Name) VALUES (2,"Dick")
>>>>INSERT INTO Test (Id,Name) VALUES (3,"Harry")

>>>
>>>well no i have a view that gets 3 names and i show them when i load the form.
>>>
>>>what you said previously looks cool i get it
>>>i have and ID problem is i cant used it like that cause it differs
>>
>>OK - show use *your* data and maybe we can tell you how to extract what you need.
>
>well its gone be hard.
>I used a View
>V_clients
>

>number                   name                           type
>1                                    jerry                             3
>2                                     peter                             2
>3                                     pan                               8
>

&& views dont look like that but i cant show pictures
>
>now i can set the control source of the text boxes
>but if i do v_clients.name thats only going to get jerry in the first text box i need peter and pan in box 2 and 3

It seems that what you want is to have three textboxes showing values from three separate records. I'm not a fan of this particular idea but I don't know the rest of your requirements so.........

SELECT v_clients
GO TOP
thisform.textbox1.value = name
SKIP
thisform.textbox2.value = name
SKIP
thisform.textbox3.value = name
GO TOP

It's disgusting looking code, but it does do what you are asking.