Main Form and Subform

[Robert]

Hi,

We are creating a database with that shows the properties we owe and the
history of leasee

We would like to implement it with Form and Subform structure. However, the
end user wants to show the leasee in descending order (Shows the current
leasee first and the oldest one last). Does the easiest way is to sort by
the lease date in the data entry form ?

Thanks

 

[Van T. Dinh]

Use a Query / SQL String as the RecordSource for the Subform and in the
Query / SQL String, specify the sort order you need, e.g. LeaseDate DESC
(for descending).

HTH
Van T. Dinh
MVP (Access)

 

[Robert]

Thank you for your advice.

Use a Query / SQL String as the RecordSource for the Subform and in the
Query / SQL String, specify the sort order you need, e.g. LeaseDate DESC
(for descending).

HTH
Van T. Dinh
MVP (Access)