HELP with Auto Tab from Control Box to subform

[tafnuef1]

Ok I am creating my first database and form in Access. I have a form and when I make a choice in my control box I want it to advance to another control box in a subform. I know I need to use a "GoToControl under AfterUpdate in the properties. But i don't think I am doing my expression correctly.

So if my control box on my mainform is called Indexer Name and my subform is called Audit Errors Subform and the control box on my subform is called Prepper Error. How would I type the expression under AfterUpdate?

HELP PLEASE

 

[sly like Coyote]

If you're going into a subform I'm not sure if GoTo will work; at least, I don't know the way to do it. I'd use a SetFocus. You'll need to do it in two steps: set the focus to the subform control, and then to the control within the subform you actually want to end up on. If you're in the main form, the code will end up looking something like...

Me.Audit Errors.SetFocus
Me.Audit Errors.Form.Prepper Error.SetFocus

You should also be aware that having spaces in the names of your tables/forms/controls etc can be a problem sometimes.