Combo box changin multiple bound combo boxes

[jamesfridman]

Hello folks,

I have a fom that displays multiple records form a table. Each record has a
combo box that is bound to the table column called Returned By.

I want to have another combo box on the form that will change the multiple
combo boxes displayed on the form that are associated with multiple records
in the table to the value that is selected in the one main combo box.

I want to be able to then save the change. Right now, I my combo box only
changes the selected record on the page. How do I make it change all of the
records that are displayed.

This is a key sign out/sign in database and the form displays keys that need
to be signed in. I want the user to be able to select their name in the combo
box and have that combo box update the Returned By fields for all of the keys
that the user wants to sign in. How should I do this?

Thanks so much.