View Full Version : update table on button click


rintaro
03-07-2000, 10:54 PM
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
03-08-2000, 08:24 AM
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