prefer tabs than navigation. navigation can be appealing UI, but very hard to reference subform and controls on subform. whenever to change tab in navigation it always requery your subform. imagine your in a record 5000 and you switch tab, the next time you return to this tab, you will be again in the first record.