I have an MS ACCESS file with a form and sub-form.
The main form shows the main RENTAL CONTRACT , then the sub-form shows the current active LEASE ;
lease has a duration of a year , then is flagged as DISABLED, and a new lease (ACTIVE ONE) is created as a new sub-record ;
The problem is when I navigate the CONTRACTS in main form ; i want to see the current active lease, but rather is shows the records in sub-form by order, so I see the disabled lease first.
How can I make the sub-form shows the active LEASE as first one by default ?