I see that this thread is pretty old, but here is a solution with Access2007. This code is attached to the form that I want to close and directs the program to open another form (frm_Utilities) and display a specific tab based on the tab control name (tab_Maintenance).
Private Sub...