>Try something like this:
>
>*-- Save current work area
>lcSaveSelect = SELECT()
>*-- Run the Query
>SELECT ... FROM ... INTO ...
>*-- Retore old work area
>SELECT (lcSaveSelect)
>
>If you already know the table alias, you don't have to save it first:
>
>SELECT .... FROM ... INTO ...
>SELECT MyTable
Hi Paul... I found the answer
1. do select...into cursor mycursor
2. thisform.fldname on the form.ControlSource="mycursor.field_name"
thats all...
to go back to your datafile
"select datafile"
thanks...
rob