Continuous Forms 3

[qwert85103]

Hello,

I have a continuous form. What should I do so that everytime I open the form fresh, it should go to the last record and not show the previous records unless I navigate manually.

thanks.

 

[Betsvigi9]

Add the following code to the forms On Open Even procedure:

DoCmd.GoToRecord , , acNewRec

 

[PHV]

Something like this ?
DoCmd.GoToRecord acDataForm, "yourFormName", acLast

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Betsvigi9]

Typo alert, it should be On Open event procedure.

 

[TheAceMan1]

Or . . . .

[blue]DoCmd.RunCommand acRecordsGotoLast[/blue]

See Ya! . . . . . .