I want to be able to copy the last record in a table a number of times and
append those copied records to the table.  I was able to create an Append
query that handles this.  My normal data entry to this table is done via a
form bound to the table.  I want to be able to run my append query from this
same form.  I have created a field for the number of copies desired and an
action button on the form, to launch the append query.  However when I
attempt to run the append query while the form is open, I get the error that
the table is already opened by another used or open through the user
interface and cannot be manipulated programmatically.

Is there any known work-around for this?  I have tried binding my form to a
query of the table, rather than the table itself, but I get the same error.

I would really appreciate any tips on this - thanks!

-- Doug