Add a tabbed control with a subform datasheets with appropriate query recordsource on each.
You won't want to constantly simul;taneously requery each, so hide the tabs and replace then with bttons which opens the appropriate tab and requeries the appropriate datasheet.