>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.


yay it > all it works. But why is that bad code?should u rather i add a new view to my table and do a select?


but it does and end of file encounter error if i put up too three and there is only one
can an IF stop the pointer from moving?

IF EOF()
&&i dont kno do what to stop the pointer?
endif 

NVm i got it

IF EOF()
Append BLank
endif

that way...there is something to show quote unquote...but i have too see if it gonna be a problem
but the code looks ugly