sort form data using a combo box

I have a form connected to an sql query and showing data. the data can be changed through the form.

I want to add a combo box that will contain the columns headers. When choosing (clicking) a header name in the combo box I want the data in the form to be sorted by the value chosen.

I guess a VB code is needed but I would not know where to start.