>OK, close each one independently by issuing:
>
>
>*Replace table1 and table2 with appropriate alias of course
>IF USED('TABLE1')
> USE IN TABLE1
>ENDIF
>IF USED('TABLE2')
> USE IN TABLE2
>ENDIF
>*ETC...
>
>
>and then when you step through it, which table creates the problem? Also, does it make a difference if you close the tables in the UNLOAD event instead (after issuing dedefault() in the unload event of course)?
>
>
Did the above, first with close tables (commented and uncommented) in teh Destroy event. Result: All tables displayed in the window were closed. No error messages while stepping thru. Of course this was with the second cmdReturn buttonthat i placed on the form, which is not the one that part of my baseform.
Commented close tables in Destroy event and placed it in Unload. Result: Went thru well.
So what does this actully tell me?
Thanks Tracy.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons