As user clicks on a particular name, its details appears in form on the right side with update button.User can click on Update button to Update his/her record in table.

Changing records manually is not only time consuming, it is also inefficient, and lends itself to errors as you update the records.

The best way to handle this type of event, the updating of many records in a database table, is to use an Update Query to make the changes to data in one operation.

You will save yourself time, and eliminate the possibility of manual errors.

Note: Due to the permanent effects of working with an update action query, you should always make a backup copy of your tables, or your database before attempting this option.

In our previous code Igniter tutorials, we explained you, how to perform insertion and deletion operation on database using Code Igniter.

Now, this tutorial demonstrates you, how to perform Updation operation on database using Code Igniter framework.Assuming your customer form is called Customer F and the customer's ID is Customer ID then you would set your query criteria to: Now any forms, queries, or reports that you build that use this query as a recordsource will show only related records for the current customer.Here is a sample database that I built that illustrates.A Microsoft Access Update Query updates specified values in a table for all records or for those records that match a specified criteria.It is possible to update records manually in a database table, either via a form or through the tables datasheet, however this may take a very long time.To run a macro or event procedure when this event occurs, set the After Update property to the name of the macro or to [Event Procedure].