>Hi all,
>
>i have a grid on a form. from time to time i put the recordsource of the grid blanc.
>thisform.mygrid.recordsource =''.
>
>Most of the time this works well but from time to time i get an error message like :
>no table is open in the current work area when i emtpy the recordsource.
>
>anybody has an idea whats going wrong ?
>
>thnx

Use a different technique (if applicable) called "Safe Select". See http://weblogs.foxite.com/andykramek/archive/2005/03/19/174.aspx for details.