updating records in table automatically

[ds_8805]

Hello. My problem is that I have table containing products and the person who is managing the product and his address. One person might manage more than 1 product. Sometimes this person migth move to a new location and change his address. Thus, the form I have created now would ask the user for the person that their looking for and their new address. When the user clicks on the a button, the vba code should be able to loop through all the records in the table and when it sees the name entered by the user, it should change their address.

I have not been able to write a proper code to loop through all the records and update it automatically. If someone could guide me along, I will be really grateful.

Thank you so much

 

[ds_8805]

hey thanks for ur reply. U mean that I create a new table where the manager will be a primary key and in the existing table the manager will be a foreign key. So I can link it up using relationship. Therefore this will be easy for me to just locate the record in the new table and change. Am I on the correct track?