>>my problem is, they don't update at once. is it the

>Try putting this before the select:
>
>SELECT realcodes
>GO RECNO()

thanks. but still, same error occurs on next entry.
when formset is ran again, data remains the same.
i thought the data environment made things automagical.
...seems like the sql's sometimes take the real tables,
sometimes the cursor of the data-env. of the form.

any more suggestions?