Solved Sorting rows on a form

[PaquettePaul]

I have a multi line subform that I use for data entry; e.g., segments of a multi-airport flight. I use the base table as my data source. My dilemma Is that after the user enters data, I have a need to sort the displayed rows in a specific order (such as flight start time) after each new record is added. There does not appear to be a sort option for the form.

A possible option is to use a query for the su form based on the specific table and put sorting in the query. Although, I do not even know if this would work In that if the user enters data in a new row, will the form save the data to the underlying table.

thanks for the assistance

 

[plog]

You can use .OrderBy -

Change the filter or sort order of a form or report

Office VBA reference topic

learn.microsoft.com

 

[MajP]

I use the base table as my data source.

Or simply build your form on a query that is based on your table and sorted by time. Then in the afterupdate of the form do a requery to put the record in the correct order. In either case (using a query or the forms OrderBy property) you want to add a requery in the after update event of the form.

 

[Eugene-LS]

to be a sort option for the form.

01. Set "Order By" your form propery as you wish
02. On "After Insert" ivent of form set code:

Private Sub Form_AfterInsert()
    Me.Requery
End Sub

 

[arnelgp]

you can also use the form's AfterUpdate event to Requery your form.

 

[MajP]

After insert will not happen if you go back and edit a time. Use after update.

 

[Eugene-LS]

AfterUpdate event to Requery your form.

That's is better way!

 

[Eugene-LS]

Use after update.

Post #7

 

[Eugene-LS]

Use after update.

... of sorting field ...
the sorting field event, not the form event
Otherwise the cursor will be reset

Together:
Use "After Insert" form ivent and "After Update" of sort field ivent.

 

[PaquettePaul]

Thank you