display last continuous subform record

[mattbeamish]

Im sure this must be easy to do (but cant do it myself...)- how do I set a continuous form subform to display the last record when a new main form record is opened? Whatever I do, the continuous subform displays the first record and I have to scroll down to get to a new record, which is getting tedious.

Thanks

Matt

 

[Pat Hartman]

The add new row is ALWAYS at the end of the recorset regardless of how the recordset is sorted. Use the >* to go to a new record. You don't need to scroll.

If you want the subform's records ordered in descending order, add an order by clause to the subform's RecordSource query.

 

[mattbeamish]

short cut key?

Thankyou that is quicker. Now I know its just because I am lazy (and also using a laptop with a horrid mouse pad which I try to avoid) but if there is no way of forcing the display of the last record in the record set, is there a shortcut key for >* so that I can just use the keyboard?

Thanks again

Matt

 

[Pat Hartman]

According to my menu (I have selected the option to show shortcut keys) It says Cntl ++

 

[mattbeamish]

Pat thanks sorry to catch up on this so late - "Cntrl +" does it - I should have read the help....
Matt