I'm glad you got it working. I would look for any dangling references or possibly the calling form has the tables already in use before this form is used? I didn't catch all of your messages in this thread so I'm not sure where the tables are opened initially or if a table is created from a view or what. By general rule, if you open a table in the form's load event, close it in the form's unload event (or that is my general rule of thumb anyway).

Tracy


>>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.