I have a navigation form setup called Home Page. It has 5 tabs in the navigation subform. Tab 5 has two navigation buttons (vbutton1 and vbutton2) which refer to different subforms (vbutton1 > frmcheck and vbutton2 > frmMultiFilter).
On frmcheck there is a button that I have a code behind that asks for the Job number and then runs a macro and pulls the necessary records related to that job. It was fine but what I want it to also do is after the the macro has run then it will switch to frmMultiFilter under vbutton2 automatically.