Updating Records in MS Access - Form and Data Access Page based update
(Page 2 of 4 )
You may edit a record using a form. Create a form as shown by using the Form Wizard. If you right click the little black rectangle at the top left corner, you can access the form's properties as shown. Here Allow Deletions and Allow Additions have been turned off by setting their values to No.
When you run the form you can change the values in the various columns except the primary key field. You may also make changes to multiple columns. You will be able to type the change in the text box; after you have made your edits, you just need to move to another record (movement can be forward or backward). The modification takes place immediately so that you can come back and verify.
Based on the form you may also create a data access page as shown, using which you can update as well. The page property is also shown alongside. It is clear that the data is updatable; the recordset is an updatable snapshot.
Similar to the procedure used in the form, just navigate to the item, edit its content, move to another record using the navigational keys and the update becomes effective. The displayed data access page is shown in the next picture.
Next: Updating data using the Update action query >>
More Microsoft Access Articles
More By Jayaram Krishnaswamy
