Forty percent of investors in their 40s expect to rely on their financial advisor for products and services beyond investment management and financial planning.