subform field shuffle
design view of my subform shows a different order of fields versus the datasheet view, how do I have my columns appear in the order I want in datasheet view?

Try rearranging them to the order you want in the table that is the control source for the subform.