1. Is there a way to either a)automatically refresh a pivot table in Access when its parent form opens or b)refresh at the push of a button through code?

2. Is there a way to email a pivot table (just the pivot table) as an Excel file from within access at the push of a button?

Many thanks.