I am having the difficulty of going to a new record in my sub-sub form.
I have created a form (Annual Cks) that has nested in it a datasheetstyle subform (Notes).
When working on this form, I was able to create a button that used the DoCmd.GoToRecord , , acNew function. First, I set
focus on the subform, and then called that "go to new record" function. It inserted a line into my subform "Notes". It worked
But when I dropped this form (Annual Cks) into a parent Form (Generator Overview), it messed it all up
Now when I click the button, it goes to a new record in Annual Cks, not in Notes! It still sets focus on the Notes
SubSubForm, and records that data I instruct it to. But after going to a new record in Annual Cks.
Ok, so the DoCmd.GoToRecord function is now referring by default to the Annual Cks. So, I go to specify the subform in the
call arguements. I get an error saying I'm referring to the wrong data type. (I specified dataform, and named the right form
name). So I try to get a macro to do it. (That way I can view the VB code generated by the macro and see if I was wrong
syntactically). But when I run the macro it says that the from isn't open! (Which, it is, in subsubform mode).
Frustratingly, when I have the curser on a line in the Notes Subsubform, I can go up to the menus accross the top and click
on "add new record, Ctrl++" and it does insert a new line. In my head, if I can do it as a user... I SHOULD be able to do it
with VB Code.
The only thing I can think that it is is something to do with the scope of the code. But I find that a bit confusing.
Does anyone have any suggestions?
Thanks so much!