how sort records in form

[Guest]

is there a way after i enter a record in a form that it will sort them in a
certain order

 

[Guest]

Try this

Me.OrderBy = "Field name to sort by"

 

[Guest]

If your recordsource is based on a query containing an ORDER BY clause, you
can just requery the recordsource. If you have a lot or records, the response
time could be quite slow.

Dorian

 

[Guest]

where do i put this code?

Try this

Me.OrderBy = "Field name to sort by"

 

[Guest]

On the After update event of a field or the form, when you want to sort the
records again