Go to last record when form opens?

[voidcranium]

I would like my form to open and automatically go to the end of the records, so I don't have to navigate to the end before I start entering data.

I have seen a form do this but can't find out how.

Thanks

 

[gemma-the-husky]

in the openevent try

application.runcommand accmdrecordsgotolast

 

[sha7jpm]

in the on open property of your form click on the box with the three dots and choose code builder..

then paste this in

DoCmd.GoToRecord , , acNewRec

the other way to do this is to make the form DE entry only (found on the properties box) but it depends on your usage for the form.

John

 

[kudar@programmer]

if thats is vb6 then its simply

adodc1.recordset.addnew

that is if you are using ado control

 

[DCrake]

Surely the most efficient way to achieve this is to have the controlsource sorted descending based on the primary key or autonumber so the last record in the table is the first one displayed on the form.

 

[missinglinq]

I don't think the OP's object is actually to go to the last record but, as others have suggested, to got to a new record.

 

[kudar@programmer]

thanks boss