>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