I am using Access 2k. Here I want to put only number i.e total no of records to be created and other fields value in a single form. Whenever I click on the Add button it will create all the recordsets with the same field value in a single shot.
Ex - table "sample" contanis VId(auto number), Name(text), Company(text)
In the form one unbound field (suppose type 100), name(type anything), company(type anything). Whenever I click on the Add Button, it should create 100 records.
Make a form based on the table that is to hold these records.
Make a macro attached to OnClick for your button.
The macro actions are
Echo Yes So you can watch them whizz through
DoMenuItem Save Record . Might be called DoCommand in A2000
SetValue The text boxes you fill in to the corresponding field in the form that is opened
Now make another macro to run that macro with RunMacro action and enter 100 from RepeatCount.
If you want it run more or less than 100 times make another unbound text box on yoru form and enter the number of times to run and then for RepeatCount enter