moving to last record

[jalldridge]

Hi guys,

I has a subform in datasheet view. Now when this is loaded I always want to be at the last record in the subform.

I've searched through the forum and am completely unsure of how to do this...

Any hints or tips appreciated

Cheers

 

[jalldridge]

I found a hack to do this...

I defined a query for the sub form rather than use a table as the source. In the query I used desending to sort on the date so that my most recent record becomes the first record in the subform.

I would still like to know how to navigate around a subform so if there are any suggestions I would be pleased to learn.

Thanks