Form Duplicate Button

[diofree]

Hi guys,
I have a standard duplicate button on my form which works well.
However, this form has a subform. Is there any way to create another button on the page that would populate the subform with "placeholder" data. This data would always be the same 10 records and i'd want the score to default to zero.

Competency 1
Score

Competency 2
Score

etc through 10

 

[MarlaC]

What is the purpose of automatically generating records with no value? What is your goal by doing this?

 

[diofree]

Basically I wanted this form to be a one-stop-shop for the user. I had hoped that they would only use the subform to actually score the ten items listed. As such, I had locked down (disabled) the first column so it could not be edited, and records could not be added or deleted - simply because every record in the main form should all have the 10 same records listed, only their scores change.

The button, or similiar method, would allow me to keep the subform working the same way. However, I can probably get by by asking the user to input the ten records for every new item created in the main form... it's just not as simple as I would like.

 

[pbaldy]

Presuming you have a table with the 10 items in it, you can execute an append query that gets values from that table plus (presumably) the ID from the main form.

 

[AccessBlaster]

See if this helps. Duplicate the record in form and subform