Automatically to last row at startup

[rarejoep]

When the Form opens, it has to go automatically to the last row in a table. Is this possible?

 

[indesisiv]

Yes, In the on open event you can use
DoCmd.GoToRecord , , acLast

That should do the trick.

Steve

 

[rarejoep]

Ok, thanks. Is it also possible to go to the last row, the row where you can enter new information?

 

[indesisiv]

For the new record use

docmd.GoToRecord ,,acNewRec

 

[rarejoep]

Thanks, it works.
I've got another question, perhaps you know the answer. I made a form and a subform in it. I want to select an item from a list, so that the subform updates. But somehow you can't select an item from the list. You can click on in, but it won't select it.

 

[indesisiv]

The only thing that springs to mind is.
Make sure that the locked property is set to no.

Not to good at thinking at this time in a morning ...

If that is not the problem then it may be worth posting the question or doing a search of the forum to see if there is anything similar.