Nadya:

>Ok, now uncomment this code one in a time. E.g. first try to uncomment only the RecordSource portion and leave out the Header's assignments code.
>
>I usually don't include buttons in the form's class... Anyway, put
>

set step on
>return dodefault()

> into the old cmdReturn to see, what is actually happening...
>
Did the above. Result: The message "Cannot access the selected table" is displayed as soon as I step to the "Close Tables" line in the code.

Here's what I have in the Destroy Event

messagebox("My cursor PatientDemo is "+ iif(used("CurPatientSummary"),"","not ") + "used")

messagebox("My cursor is "+ iif(used("CurPatientSummary"),"","not ") + "used")
messagebox("My cursor is "+ iif(used("CurOnGoingHealth"),"","not ") + "used")
messagebox("My cursor is "+ iif(used("CurTreatment"),"","not ") + "used")
messagebox("My cursor is "+ iif(used("CurConsultants"),"","not ") + "used")

CLOSE TABLES
MESSAGEBOX("Tables are closed now.")