Append/Update Query to add multiple records to Table?

[DougW via AccessMonster.com]

Hi - I am not very proficient in Access so please bear with me.
I have a table where very often I will have many identical records in a row
(maybe 24 or 36).
All fields in a given set of records are identical (except for the primary
index). Later on one
of the fields in the duplicate records will be changed.

For my initial data entry, I have created a form that will let me create
individual records in
my table. I have an "add record" icon that will create one record. That
works okay so far.
I have also set default values so the fields in the form will default to the
previous entry.
That works okay too. But I have to go in and edit one field before the form
will let me add
another duplicate record. In other words I can't just click my "add record"
icon 24 times -
I have to edit - "add" - edit - "add" - etc, 24 times.

As an alternative, I was wondering if I could add a field to my form with the
number of repeat entries desired. Then an "add repeat records" icon that
would run an update query or append query that would add the required number
of duplicate records. Might this work? If so, how could I set it up?
I would appreciate any advice - thanks!
-- Doug

 

[DougW via AccessMonster.com]

Update - I've got it working (sort of) by using an append query.
My problem now is the append query won't run while the data entry form is
open.
I'm attempting to run the append query from an action button on the form.
The query also looks for the number of duplicate records selected on the form.

But since the form is bound to the same table as the append query is trying
to add
records to, I get the "table is already open..." error.

Is there any way I can run the append query while the form is still open?

thanks