>>Something very simple I think and I'm sure I have done this before
>>
>>I want to scroll through a table lets call it orders table has approximately 100 records - on the form I display the record number
>>
>>At each record I want to clear a text box on my form and scan in a value then move onto the next record and so on
>>
>>How do I do this simply - can someone give me some code - I am totally confused with this one
>>
>>Thanks
>>
>>Colin
>

>select myTable
>lnLoop = 0
>scan
>  try
>  lnLoop = m.lnLoop + 1
>   loTextbox = evaluate('thisform.textbox'+ transform(m.lnLoop))
>   loTextbox.value = myTable.SomeColumn
>  catch to ....
>  endtry
>endscan

Thanks Naomi

I will give it a try and let you know

Colin