Running the Project
At this point, you’re ready to run the project so click F5. The form
(in Figure A) displays the first record in the bound table (from Nwind.mdb).
Click the navigational controls to move from one record to another. Remember,
if you change the data in a record and then move to another record, VB will
save the change.
Try to add a new record by first clicking the Last button and then clicking
the Next button. The first click will display the last record in the bound table.
The second click will display a blank record--if you’ve set the data control’s
properties accordingly--as shown in Figure B. If your form doesn’t display
a blank record, return to Design View, select the ADO data control and change
it’s EOFAction property to 2 - adDoAddNew.
Figure B
Once you view a blank (new) record, you may encounter a problem if you try
to return to a previous record. If your form includes any required fields, VB
won’t let you leave the new record until you enter something in the required
fields. This behavior includes primary key fields and any required fields you
may not have displayed on your form. You can however, exit your form by clicking
the Exit command button.