Try it like this:

YourSubformName.SetFocus
YourSubformName.Form!YourFieldName.SetFocus
DoCmd.GoToRecord , , acNewRec

Value From a Form
Value From Subform

Thank you very much for your reply!
Yes I tried that too already.
But still, it just doesn't move to the new record... (only works when I put the code on the subform itself... But that just complicates stuff in my case..)

That's weird. I tested the code and it works for me. Can you post a screenshot of your form and the exact code used?

Hi Nils Markgraf, SetFocus doesn't work in some events, so please post the entire event procedure where SetFocus is used and doesn't work.  Also, a control can't have focus if it is invisible or disabled.

You said in your original post that you are clicking on a button on the parent form. Why are you using an After Update event?

First of all thank you guys very much for your help!

I narrowed my problem down a bit further:
My subform is actually a subform inside another subform. So it is MainForm.Form!Subform1.Form!Subform2.Form
The DoCmd.GoToRecord , , acNewRec needs to happen on Subform2
The code, which is located in an AfterUpdate Event, is firing on Subform1.

I just tried the whole thing without the nested subforms, so it was only one Mainform and one Subform, then it worked!
But as soon as I try to do it with the two nested subforms, I can't get the DoCmd.GoToRecord , , acNewRec to get working...
The SetFocus still works though.. (my code can be seen on the screenshot above)

Sorry I was being inaccurate before!
Its not a button, it is a Combinationfield, the code is in the AfterUpdate of that (SuchKombo)

Not sure what you mean by CombinationField. I am assuming you mean Combo Box.

Now that we know it is a nested Subform, try this:

Subform1.SetFocus
Subform1.Form!Subform2.SetFocus
Subform1.Form!Subform2.Form!FieldName.SetFocus
DoCmd.GoToRecord , , acNewRec

Replace Subform1 with the name of the outermost Subform.
Replace Subform2 with the name of the innermost Subform.
Replace FieldName with the name of the field on Subform2 you want to set focus.

Again, I have tested this code and it works perfectly for me.

Oh yeah I mean Combo Box, Sorry! My Access is in german and sometimes I forget the original terms...

This code works, when being placed on the main form.
But my combo box (and therefore the AfterUpdate Event) is placed on Subform1.
And then, the code doesn't work anymore...

I'm really sorry and again I really appreciate your help and your time that you're investing!!

Okay, so I set up a test and ran into the same problem trying to go to a new record in Subform2. So made a slight change. Give this a go and let me know if it works.

Subform2.SetFocus
Subform2.Form!ProductName.SetFocus
Subform2.Form.Recordset.AddNew

YES! That on worked!!!
Thank you so much Kevin!!!
Without your help I would have gone crazy I think.... XD

You're welcome.