Show only most current record

[DenisCooper]

Hi,

i've designed a rental database (which seems to do what i want) - it's not perfect....

But i can't figure out how to accomplish this.

If i have a tenant, who has previously had a lease agreement on one of my properties, but then moves out, and then moves into one of my new properties, i can't seem to see how to get access to display just the new lease details.

I've attached a blank copy of the DB with some sample data to illustrate this.

you will see that test tenant has two leases, one expired lease, and one active lease, but on the main form it just shows the expired (original lease)....

i'm by no means an access expert - so any help greatly appreciated.

thanks

 

[G37Sam]

Can you upload it in 2007 format or even mdb please? I have a feeling it's a query issue but nothing that can't be fixed

 

[DenisCooper]

Hi Sam,

thanks for getting back..i've just tried saving it in 2003 format but itwon't let me....

it says it should be compatible with 2007 though

 

[DenisCooper]

i managed to fix this by changing the form source to a query and it works okay now

thanks