<div>
How are you selecting?<br />
<br />
To be sure of being able to do this you need a BOUND checkbox (so a field in the table) so that users can select by clicking the checkbox.<br />
<br />
However there can be issues if you have multiple users doing this at the same time.<br />
You then need to look at using a local table that has ID values and a yes/no field and you include this table as part of the recordsource. <br />
<br />
If you are ALWAYS selecting contiguous records then it is possible to use code without a checkbox but this solution will not work if there is any gap in the selection.<br />
<br />
So back to the question at the top....
</div>


How are you selecting?

To be sure of being able to do this you need a BOUND checkbox (so a field in the table) so that users can select by clicking the checkbox.

However there can be issues if you have multiple users doing this at the same time.
You then need to look at using a local table that has ID values and a yes/no field and you include this table as part of the recordsource.

If you are ALWAYS selecting contiguous records then it is possible to use code without a checkbox but this solution will not work if there is any gap in the selection.

So back to the question at the top....

<div>
I was really looking for compact code that uses SelHeight or similar.
</div>


I was really looking for compact code that uses SelHeight or similar.

<div>
&lt;Append Selected Records to Another Table&gt;<br />
&lt;I was really looking for compact code that uses SelHeight or similar. &gt;<br />
<br />
Another approach would be to use a listbox to display the records.<br />
<br />
Then you could even select non-contiguous records, ...then easily collect the ID's, then copy the records based on the collected ID's...
</div>


<Append Selected Records to Another Table>
<I was really looking for compact code that uses SelHeight or similar. >

Another approach would be to use a listbox to display the records.

Then you could even select non-contiguous records, ...then easily collect the ID's, then copy the records based on the collected ID's...

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
Has anybody got some nice function/code to copy selected rows of a continuous form/subform and append them in the same/another table?<br />
<br />
Gary
</div>
</div>


Hi Experts,
Has anybody got some nice function/code to copy selected rows of a continuous form/subform and append them in the same/another table?

Gary

Append Selected Records to Another Table

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.