Sorting in form 1

[scra]

I have a subform that needs to be sorted by review date (review_dt) in descending order when the form is opened. What and where do you insert a code?

 

[PHV]

Simply use a sorted query as the RecordSource of your subform.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[scra]

Thanks. Sorry, I left one thing out. The form is updatable to populate a table. The clinicians use it to enter in the form the clinical information. They would like to see the most current review date when the form pops-up.

 

[PHV]

Again, use a query (instead of the table) as the RecordSource.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[scra]

Thank you! I've implemented the sort query in the record source.