How to go to last record in my form?

[ozean]

I have a form with a subform. When form is opened it always starts with the first record. How do I get the form to display the last record when opened? As the form contains monthly bills I have to step thrue all months to come to the last month everytime I will add a month.

Regards
Stefan

 

[ZmrAbdulla]

[tt]DoCmd.GoToRecord , , acLast[/tt]
to go to last record (on open event)
---------------------------------
for the sub form
you can set the subform recordsource to a query sorted descending the record number. Then the last number will be on top


________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[ozean]

Thanks!!!