Navigating from Form to SubForm

[Gryphen957]

It took me a while, but I finally figured out how to create an 'on exit' macro to automatically navigate from a control on my parent form to a control on my subform. Everything was working fine until I created an 'on load' macro that automatically started a new record on the parent form.



My problem at this point is that when I open my form and try to renter the subform, I get an error. I'm told that my subform is not a control that can gain focus. Once I clear through the error everything works fine, until I load the parent form again.

Any ideas what I'm doing wrong?

[Gryphen957]

ANSWER:
The 'On Load' macro in the main form was initiating an 'On Exit' macro in the subform. I didn't notice at first because, for some reason, the 'On Exit' did not actually initiate until I began entering information in the main form. Revamped the "On Exit' macro and everything works fine.