Sub Forms

[buhgman33]

I have a continuous subform in a main form. The subform does not allow additions. I have a command button that will allow the user to add an additional item into the subform. How do I get the curser to go to the new record line. The subform is long and does not show fully, and I do not want the user to need to scroll down.
I have tried the DoCmd.GotoRecord command but it is not accepting the form name. It is telling me the the form is not open.
This is the exact line I've used.
DoCmd.GoToRecord acDataForm, "Me!Child14.Form", acNewRecord
(Child14 is the subform).
Please let me know if this can be done and is it that just my syntax is wrong.

 

[TheAceMan1]

How are ya buhgman33 . . . . .

Cannot use the [purple]dot (.)[/purple] operator in a formname.

Turn [blue]AllowAdditions[/blue] on thru [blue]your button[/blue], then off in the [blue]AfterUpdate[/blue] event of the form.

See Ya! . . . . . .