Your partner can still go abroad for work or holidays as the OR places no restriction on travel. However he may well have to pay into an Income Payment Agreement for 36 months, which could make expensive holidays a bit difficult!
Your partner won't be able to obtain credit over £500 without first advising the potential creditor, he won't be able to hold certain positions (MP, councillor etc), he cannot carry on business in a different name to which he was made BR, form a limited company or act as a company director.
Have a look at the Insolvency Service website as there is a lot of information there - www.insolvency.gov.uk
Tomorrow is a mystery, yesterday is history, today is the present, a gift to make the most of.