SetFocus on Field in subform

[quicova]

Hi Everyone.



I'm trying to right a code to set the focus on a field in the last created record on a subform.

I have a subform and a listbox side by side.
I created a double click even that adds data from the listbox to the subform, but I still need to manually add more values.
So I wanted to set the focus on the next field in the subform on the last created record.

I tried
[Forms].[mysubform].[specificField].SetFocus but that didn't work
For sure I need to tell to go to last created record in the subform and them tell which field to set the focus.

Anyone has any ideas on how to go about this?
Thanks so much
Quico

[pbaldy]

See here for the correct syntax:

Forms Refer to Form and Subform properties and controls

[quicova]

UAU that is awesome information.
Thanks so much.
It stopped giving me the error but it still doesn't set the focus on the last created record.

I'm trying something like this but I can't make it work

Me!Add_to_Weights_SUB.SetFocus
    Me.MoveLast
    Me.Quantity.SetFocus

Any ideas?

Subform name is Add_to_Weights_SUB
Field name is Quantity

[pbaldy]

Try

Me.tblTestsubform.SetFocus
DoCmd.GoToRecord , , acLast

[quicova]

Thanks it work.
I forgot about the GoToRecord command.
Thanks so much

[pbaldy]

Happy to help!