I have a form that has a datasheet subform. The datasheet subform by default opens with just 10 records displaying. It's record source is a top 10 query. But on the main form I have a command button which when clicked I want the sub-form to display ALL the records in the table.
What would the onclick event of the command button be?