cannot edit after sort

[liddlem]

Hi all
I am using a split form to find and edit existing records.

On the form I have set the following properties.
Split for Datasheet = Read Only
Allow Addition = NO
Allow Deletion = NO
Allow Edits = YES
Allow Filter = YES
Order By = [BLANK]

So long as I use the form in this 'default' format - I am able to edit the record.
However - If I choose a field in the split form and then sort by that field, the records are no longer editable. (The 'Order By' value get updated to whatever field I have sorted by)

How can edit records after I have sorted my list?

 

[Ranman256]

Don't sort using properties, use a query that sorts the field you want.

 

[Minty]

I think this is a weirdness of the using inbuilt split forms, the split portion of the form acts very oddly if you modify any of the default behavior.

Most people develop their own sub forms and then are able to do what ever you like with them.

 

[liddlem]

Thanks Minty
If I understand you correctly, then what you are proposing is that I create a main form with a sub-form.

The main form displays :
1. A single record from a query and
2. Is linked to the subform. (IE. as a record is selected on the subform, the corresponding record is displayed for editing.

The Sub-Form is :
1. Based on the same query as the main form.
2. A non-editable datasheet that is both filter-able and sort-able.

Kind of defeats the purpose of using split forms doesn't it?

 

[Minty]

Thanks Minty
If I understand you correctly, then what you are proposing is that I create a main form with a sub-form.

The main form displays :
1. A single record from a query and
2. Is linked to the subform. (IE. as a record is selected on the subform, the corresponding record is displayed for editing.

The Sub-Form is :
1. Based on the same query as the main form.
2. A non-editable datasheet that is both filter-able and sort-able.

Kind of defeats the purpose of using split forms doesn't it?

Short answer - yes - If you have a search on here you may find some work arounds - there have been some threads recently exploring the foibles of split forms, and the general opinion from the more experienced folks here seems to be "roll your own".

Some of that may well be simply that we've always historically made our own subforms, even datasheet imitation ones, because of the additional control you get over how they work.