<div>
<div class="content wysiwyg-content">
I have a form that has a datasheet subform. &nbsp;The datasheet subform by default opens with just 10 records displaying. &nbsp;It's record source is a top 10 query. &nbsp;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.<br />
<br />
What would the onclick event of the command button be?<br />
<br />
--Steve
</div>
</div>


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?

--Steve

Refresh datasheet form with all records

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.