Dynamically order columns MS Access subform

Question

I need to re-order columns in MS Access form on click of the button.

1. If Column Sequence1 button clicked order should be Col1, Col2, Col3
2. If Column Sequence2 button clicked order should be Col3, Col2, Col1
3. If Column Sequence3 button clicked order should be Col2, Col1, Col3

Please refer below screenshot for the reference

I tried, but column order is changing only when it is saved manually in the mainform or Subform. Please help on VBA script