help with getting the latest record to show up

  • Thread starter Thread starter Bhagya
  • Start date Start date
B

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
 
Bhagya said:
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.
Click to expand...


What determines the "latest" record?

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