>>I suggested setting a filter because you will only have to deal with one table and your underlying framework (relations, etc) should not have to be re-established.
>>
>>Make sure you are Requerying and refreshing. Also pay attention to what Bruce is saying. This is especially important with a Browse.
>>
>>One alternative is to add another page to your page frame Tillted Old Parts. Just let them click onn it to show the other data source.
>>
>>Personally I am not too wild about closing down & re-opening data sources in the middle of an active form.
>>
>You're right, of course, I don't generally do that with tables, just with cursors for certain reasons...but I thought he was actually opening a new table with same structure as old one, then he would need to reset source...but maybe loading all data into one table is the best idea...
What John is doing is a scary concept for me. I just can't get past the amount of overhead required to display tables. I like setting up my DE & then leaving it alone as much as possible. Kinda like: 'if it ain't broken, don't fix it'. (s)
Tom