Add AGAIN. There is no downside with using again, as far as I know, so I more or less use it always. I suggest you also add an alias
under myform procedure load
use mstr IN 0 again alias alist amstr
use trans1 IN 0 again alias atrans1
use book1 IN 0 again alias abook1
use temp IN 0 again alias atemp
use book2 IN 0 again alias abook2
>hi,
>thank you for reply,
>i get error message(file is in use)
>
>under myform procedure load
>use mstr IN 0 (file is in use)
>use trans1 IN 0
>use book1 IN 0
>use temp IN 0
>use book2 IN 0
>
>
>any simple example about
>You could use a prvate datasession and do so in form/class.Load() for example, or try the "visual" Form Designer and let the form.DataEnvironment care for your tables automatically.
>
>thanks.