If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Inserting a New Record into a Table
What is the best of way of inputting new data into an exiting table. I have
setup a form that links to the table with a save record command button, but each time I open the form, it displays the data from the first record in the table. I want all of the fields to be blank - I would like it to be inserting a new record in the table. Any help would be appreciated. Paul |
#2
|
|||
|
|||
Inserting a New Record into a Table
"Paul" wrote
What is the best of way of inputting new data into an exiting table. I have setup a form that links to the table with a save record command button, but each time I open the form, it displays the data from the first record in the table. I want all of the fields to be blank - I would like it to be inserting a new record in the table. Take your choice: If you've left the Navigation controls on the bottom of the Form, you can click the one marked *, which will move to a new record, or In the Data tab of the Form's Property Sheet, set the Data Entry property to Yes, in which case, it won't display anything but new records. If your Form is bound, I am at a loss to understand why you need a "Save Record" button, as Access will automatically save when you move off that record, or close the Form, or move the cursor into a Subform Control, and possibly a few other pertinent times. Larry Linson Microsoft Access MVP |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Displaying File properties on a Access 2000 Form | Chris Fillar | General Discussion | 2 | March 16th, 2006 02:22 PM |
Add New Field to DB | Karen | Database Design | 7 | October 19th, 2005 08:03 PM |
Unable to edit records in a form or query | Merlin | Using Forms | 7 | May 10th, 2005 02:00 PM |
strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |