||Wizard generated form - data input
||Tue, 09 Apr 2019 16:48:11 -0400
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.
Thanks in advance!