update table on button click

[rintaro]

i have a form for inputing data. during testing, the underlying table gets updated automatically and moves to the next record once the last field is filled out (this, i believe, is normal). i want the input clerk to be able to look over the data and press a button before it goes on to the next record. any ideas how to do this?

 

[dennyryan]

1. Change the Cycle Property of the Form (listed under the Other Tab) to 1
This will cause the focus to shift back to the first field after the user tabs through the last field.

2. Use the Command Button Wizard to add a button for Adding a New Record. Once that is setup when the user clicks on it, the current data will be added to the database and the form will be cleared ready for the next record to be entered.

Denny