last record on opening form!!!

[MISGUY1]

Hi Experts,

I am new to Access, I created a form that shows the tables values. but when i open the form it shows the first record and i have to click end to display the last record. is this possible that whenever i open the form it should show last record? Any help will be appreciated.Thanks in advance!

 

[PHV]

Bind your form to a query having the right ORDER BY clause.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ProgramError]

Also..
DoCmd.GoToRecord , , acLast
used in the on open event will jump to the record without altering the sort order.

Ian Mayor (UK)
Program Error
9 times out of 10 I know what I'm talking about. This must be my tenth reply.