Inputting many records of data

[porton]

I want to enter several hundreds records.

For this task I have a form with "Submit" button whose "Action" is "Save record".

I want the form to be reset after entering a new record (to have a fresh form to enter the next record). How? Do I need Star Basic scripting? Or it can be done without programming?

[Villeroy]

There is a form property to allow new records only.
Very small example to enter integer numbers with a next-record-button as default button and a second independent form to show the sum of the entered figures: http://user.services.openoffice.org/en/ ... hp?id=3048
Going to another record stores the current record (if all constraints are fulfilled).

[porton]

There is a form property to allow new records only.

1. But what if I want to use the same form for adding new data and for editing existing records?

2. You have not answered to my question how to make the submit button not only to save the record but also to reset the form to the initial state for entering the next data record. I suppose this is impossible without StarBasic programming.

3. When "Add data only" is "No", when I open the form it selects the first record from my table. How to open the form with an other (non-first) record selected in the table?

[Villeroy]

When you move from a newly entered record to the next record the next record will be another new one. This works even without any button if the forms cycle mode is set to "Default". The Tab key jumps from the last control of a new record to the first control of a the next new record. You can test this quite easily with my simple form in counter.odb. Reset it to allow anything and disable the next-record-button. When you open the form you have to jump to the very last record (new record), enter a number and hit Tab in order to store the entered number and enter the next new record. The second form for the sum is separated. You can ignore or delete it in this context.
You see the same behaviour in the grid view of your table. Enter something into the very last (new) record and tab until you reach the next new record.