I have a form with two controls. A combobox that lists the names of 5 fields within my table and a text box. The objective is to have the user pick a field (using the combobox) and then enter the text that they would like to update all the values in that field to.

I'm having trouble creating one update query (instead of one for each option in the combobox) that update the values in whichever field the user selects to the text value that they enter. Any suggestions? Thanks.