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.


http://i54.tinypic.com/b53329.jpg
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.