<div>
THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! <br />
I have been stumped on this for hours!
</div>


THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU! THANK YOU!
I have been stumped on this for hours!

<div>
No problem, you're welcome...:-)<br />

</div>


<div>
<div class="content wysiwyg-content">
Hello - how do you reference a subform in the {ObjectName} arg of DoCmd.GoToRecord?<br />
<br />
I have a global module for form operations where I do common things for Open, Current, add's, edit's, deletes, etc. &nbsp;I pass the form as an object variable. This has worked well in the past, on stand-alone forms, but now I'm trying to re-work it to handle forms that are open as subforms. For my add routine, I go to the NewRecord:<br />
<br />
DoCmd.GoToRecord acDataForm, frmThisForm.Name, acNewRec<br />
<br />
It errors back with &quot;(subform name) isn't open&quot;<br />
<br />
Thanks<br />
<br />

</div>
</div>


Hello - how do you reference a subform in the {ObjectName} arg of DoCmd.GoToRecord?

I have a global module for form operations where I do common things for Open, Current, add's, edit's, deletes, etc.  I pass the form as an object variable. This has worked well in the past, on stand-alone forms, but now I'm trying to re-work it to handle forms that are open as subforms. For my add routine, I go to the NewRecord:

DoCmd.GoToRecord acDataForm, frmThisForm.Name, acNewRec

It errors back with "(subform name) isn't open"

Thanks



DoCmd.GotoRecord on a subform?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.