I have a navigation form setup to open a dialog box (dialog form) when I click on one of the tabs (think buttons). After the dialog box is filled out and ok is clicked I want the dialog box to hide itself (me.form.visible=false I think) then I need it to load a form in the navigation subform I can make it just open using macros but it will just open it in a tab or as a dialog box rather than putting it into the navigation subform. I would prefer not to have to right VBA code Except where absolutely necessary. Here is a link to a basic screen shot keep in mind my dialog box is not open in this screen shot.
I'm sure this can be done im just not sure how to go about it and im still a serious novice when it comes to Access and VB/VBA. Any help would be greatly appriciated.