>Hello Nadya:
>>
>>I glanced through the code, but I don't see, where do you assign anything to combobox recordsource.
>
>RowSource is:
>
SELECT ALLTRIM(UPPER(Last_Name))+", "+ALLTRIM(UPPER(first_name)) as FullName, Health_Num FROM patient INTO CURSOR PatientDemo NOFILTER ORDER BY patient.last_name
>
>RowSourceType = 3
Ok, the little problem with this select - you should padr the result to some number, e.g.
SELECT padr(ALLTRIM(UPPER(Last_Name))+", "+ALLTRIM(UPPER(first_name)),40) as FullName,...
But it's unrelevant observation.
>
Can you check, if PatientDemo is used?
>>Also, may be the problem is that these cursors are somehow closed. Do you know, where do you close these cursors?
>
>I CLOSE TABLES in the Destroy event only, while other action buttons like Save, Delete and Edit simply rebuild the respective cursors to reflect teh change.
>
>Total confusion huh:) (for me it definitely is)
I would comment out CLOSE TABLES in Destroy (you don't need it if you have AutoClose set to .t.) and see, if it makes the difference. In any case, it sounds like these cursors are already somehow closed, which should not be. Can you find out, what method closes them?
If it's not broken, fix it until it is.
My Blog