show Last record of associated table

[gulsarwar]

i want when i open the form it show only last record of associated table instead of first record. plz help

thanks

 

[gemma-the-husky]

general access behaviour is to show the first record of any dataset

so use a query (rather than the table) sorted in the order you want (ie reverse date or whatever) and there you are

 

[gulsarwar]

isn't possible with vba coding on form load event?

 

[gemma-the-husky]

try

Application.RunCommand acCmdRecordsGoToLast

 

[gulsarwar]

thanks its nicely working