Hi Michael,

You could break the table lookup and the data processing into two separate forms. The first from would be called and the user could use the incremental search to select which table he wanted to process. Then have a button that calls the from with the grid so the user can work with the selected table (e.g. insert, delete, and update data). When the user is finished with the form that has the gird, he/she could release it and return to the form that perfroms the lookups. Then the user could either relase the lookup form or perform another lookup and call the form with the grid again.

In this way the from with the grid would be restarted each time a new table is selected, as opposed to refreshed with a different record source, and your form's grid would retain all it's custom property settings and method code.