Subject Re: Wizard generated form - data input
From Akshat Kapoor <>
Date Wed, 10 Apr 2019 15:09:02 +0530
Newsgroups dbase.getting-started

On 10/04/2019 02:18, Kent wrote:
> I have a table (Medical_data), and two forms. medical_browse and medical_edit. All fields are data linked.
> The medical browse form opens with a query that sorts the rows in year, month and day order. It is working perfectly.
> The problem is the edit form. I need the rows sorted in order to find rows I need to edit. I guess that by design, somebody cannot change data in a query form. Since I need to find and edit, I have tried to unlock the form with, using various tools such as Edit, unlock, the data edit button ect. The form just ignores them or generates errors.
> The form always generates "rowset is read only".
> How can I unlock the edit query generated form, and still have it sorted?
> Any help would be appreciated.

Just recalled another way.
Instead of using the order by clause in sql to set the orders you can
use the indexName property of the rowset to set the required order.