Go to the last record on subform

[dotcanada]

Good day.



I'm having an issue with a subform.

I currently have the following VBA code in the subform's On Current event:
DoCmd.RunCommand acCmdRecordsGoToLast


No I have a problem. Whenever I want to add a new record on this subform, it tells me that I can't go to the specified record.

Obviously, I'm not using the right code to go to my last record when I open the form. But what would I use, and where?

Thanks.

[dotcanada]

Crisis averted.

I placed this command in the MAIN form's On Current event, but I had to set focus first. So this is what I have:

Me.name of subfrm.SetFocus
DoCmd.RunCommand acCmdRecordsGoToLast

Works great now.

[aytee111]

Or in the subform's OnLoad event: DoCmd.GoToRecord,,acLast

[dotcanada]

Apparently, my solution above didn't work. And I tried your suggestion aytee. It didn't work in the OnLoad event. But it did work in the OnCurrent event.