way for user to populate multiple rows to a table from a form

[BrockWade]

Does anyone have any design tips on a way for user to populate multiple rows to a table from a form? Ideally the user would enter data in one "cell" hit enter and go to the next cell, etc. Then after the user was satisfied with the entries the user would hit a button that would save the data to a table... thoughts? Thanks

[Dal Jeanis]

Not sure what you are trying to achieve. A) If the user is only entering one value at a time, why not use a continuous form and have the data saved as it's entered? B) If you didn't want it committed, you could have the form bound to a temporary table, and have your "Save" button transfer the termporary records to the permanent table.

[BrockWade]

The temp table idea was great, working well.... Thanks!

[Dal Jeanis]

No problem. Please mark thread "Solved". Top of page, under thread tools.