before refreshing the tables, set recordsource to '' and then reset it back after refreshing.

>We have grids that are bound to temporary tables, these tables get refreshed with the standard recordsource="PAYTEMP" for example, unfortunately all of the standard base methodology that was associated with the textbox / combobox within the grid is lost when you reset the grids datasource...
>
>Is there an easy way around this..
>
>Please note the temp table is NOT within a database as it is created from an ODBC call to an SQL server etc...
>
>THANKS
>
>Keith
>
>PS: another problem is grid scroll bar bleed through when we have another control overtop of the grid, sometimes the darn up down arrows pop through when scrolling another grid overtop... looks like a FOX error, but who knows...