Access create an append query that can duplicate a record a number of time based a value in a table

[cres1121]

I would like to add to a table via form a certain number of lines. The number of lines are not always the same sometime it could be 1, 5, 30 or now I have one that is 430 lines.

I would like to copy an existing record and them when I call this feature I would like it to ask how many records should it create. I want to then say 30 and hit enter and it will then add those records into the table 30 times.

I want to only call upon it when I need it.

There is one table it is affected by
linenumber PK Autonumber
ServiceContractnumber FK Number
Serial Number Text
Decommissioned Date Date
HWSWPart FK Text
Comment Text
HWSW Reference FK Text

[ssanfu]

I think you will need to use VBA and loop the number of times you want the new record to be inserted (appended).

BTW, do not include the field "linenumber ". It is the PK and by definition unique. Being an autonumber, the value for "linenumber" will be created automatically.

[NTC]

you post this to be lines 'via form' ..... and the question is how is it that a form has 1 to 430 lines? are you saying an unbound form with a single unbound text box - meaning that these are lines within a text box?

the best approach is to have the form bound to a table....it will then allow unlimited rows (lines) ... it could be bound to your table directly - that would solve everything; But the form could be bound to a temp table for some reason - and then have an append query write it to the final table.