How to update only particular column in DB(MS-Access)

Question

Hi guys,

I would like to learn the best way to update the database.

The situation is:

I'm having some textboxes(> 3) on a form. I need to update the db columns with the text from textboxes which means the db has 3 columns, repressents each textbox.

Let say only textbox2 is edited. How should i update only the column related to textbox2 and not looping the whole columns to find where the edits need to be updated?

Any idea guys?