help with getting the latest record to show up

[Bhagya]

Hi,

I have a contracts table where each contract can be from
1 - 5 years. Currently when I want to create a renewal
contract, I have a form that duplicates the contract
record.

But the duplicate record chooses the first year contract,
my question is what should I do to have the latest record
show up when I want to renew.

I am having the old record show up because I want to make
changes only to a few fields and the rest are the same.

Any help would be appreciated

Thanks
Bhagya

 

[Marshall Barton]

Hi,

I have a contracts table where each contract can be from
1 - 5 years. Currently when I want to create a renewal
contract, I have a form that duplicates the contract
record.

But the duplicate record chooses the first year contract,
my question is what should I do to have the latest record
show up when I want to renew.

What determines the "latest" record?

What sequence of code are you using to duplicate the record?

 

[Guest]

You could have the query of the form open in decending date order.