Continuous Form Problem

[karassik]

I have a continuous subform in Access 2000.

I would like to open to always go to the last record in the continuous subform, unless I'm adding a new record. I put in the onCurrent event. Goto last record, but it won't let me out to go to a new record. I thought I could use onActivate, but I'm not having any luck.

Nishan

 

[SBendBuckeye]

Try something like this:

If me.form.newrecord then
DoCmd.GoToRecord , , acNewRec
Else
DoCmd.GoToRecord , , acLast
End If

 

[karassik]

On which event procedure? OnOpen?

 

[SBendBuckeye]

Depending on what you want to do, either On Open or maybe also On Current. Sorry and Good Luck!