i want when the form open it goes to last record.i am using this on open form event and working any other way
DoCmd.GoToRecord , , acLast

Hi

Sorry - I don't understand your question.....do you mean it's working as you want but you're looking for a different way of doing it ?

Could you explain a bit more..............?

hi
i want when the form opens it automaticaly goes to last record..
is there any default property to do that.or have to use the code
i am using this code on open event.

The code you're using should do what you need. There's no default setting as far as I know........

Is there any reason for not using the little bit of code?

Alan,

I think he wants to go to a 'new' record, it being the last.

Try:

DoCmd.GoToRecord , , acNewRec

Should do what he wants.

Good luck,

Aqua