MultiSelect.accdb

<div>
In similar cases where such functionality was needed i was forced to have a temp table which had exactly the same structure as of my source table/query but with the addition of a single Yes/No field so that the continuous form had the functionality to select/deselect and in your case calculate sums<br />
So just before you open the form you clear the temp table ,append the records you want and base your continuous form on this temp table ...<br />
Since the Yes/No representation --&gt; checkbox is bound you can easily manipulate it
</div>


In similar cases where such functionality was needed i was forced to have a temp table which had exactly the same structure as of my source table/query but with the addition of a single Yes/No field so that the continuous form had the functionality to select/deselect and in your case calculate sums
So just before you open the form you clear the temp table ,append the records you want and base your continuous form on this temp table ...
Since the Yes/No representation --> checkbox is bound you can easily manipulate it

<div>
<div class="content wysiwyg-content">
Dear experts - <br />
Is there a way, as you select one or multiple row in a continuous form, to update an unbound field on the parent form with, for example, the total number of records selected (and, ideally, the total of a given field in the selected records)?<br />
Many thanks -
</div>
</div>


Dear experts - 
Is there a way, as you select one or multiple row in a continuous form, to update an unbound field on the parent form with, for example, the total number of records selected (and, ideally, the total of a given field in the selected records)?
Many thanks -

continuous form - multiselect and show total?

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.