I'm probably forgetting something really simple, but it escapes me as to what it is.:(

If got a subform, which gets a record inserted into it based on clicking an image on the main form. I want the focus to move to the last record of the subform after the image is clicked.

I've tried DoCmd.GoToRecord , "Subform", acLast
but that doesn't work,
nor does referring to the subform as Form_Subform or Forms!Form!Subform

Can someone tell me where I've been going wrong?

TIA

Steven


I am a loud man with a very large hat. This means I am in charge.

__________________
<hr noshade size=\"1\"><i><font color=\"blue\">I am a loud man with a very large hat. This means I am in charge</i></font id=\"blue\">

You must set the focus to the subform first, then the docmd. Here's what your code would look like:

    ' Set focus to the subform
    NameOfYourSubForm.SetFocus
    ' Move to the last record on the subform
    DoCmd.RunCommand acCmdRecordsGoToLast


John Ruff - The Eternal Optimist :-)

Doesn't seem to work.
The focus basically stays on the subform the whole time, since there are no focusable controls on the main form - and it still just stays in the first record.

Would the fact that it's a continuous form somehow have something to do with it?

Steven

I am a loud man with a very large hat. This means I am in charge.

Try this:

On the Subform's Enter event add the following code:

DoCmd.RunCommand acCmdRecordsGoToLast


John Ruff - The Eternal Optimist :-)

I'm obviously not that clever - I overlooked a little command after the GoToLast that screwed it all up - DoCmd.Requery

Once again - I'm not that clever

Steven

There are 10 kinds of people in the world - those who understand binary - and those with friends