In the form, "filteredForm" below ... you can see my sql statement being assigned to the recordsource property of the form.
On this form is a set of textboxes bound to the forms recordsource (see below).
This form's default view is datasheet.
Me.filteredform.Form.RecordSource = "select ConversionID, ProductID, AlternateProductID, QtyCONV, ProductClassID, ProductClassIDCONV, ProductClassCONV, ProductGroup, ProductGroupCONV, DistributorProductID, Inactive " & _
" from tblConversion where Convtype ='B'"
Columns however in the datasheet are not showing in the same order as the sql query or the text boxes on the form.
How do I control the order of the columns displayed? Any insight into what might be throwing the order off from sql or on the form itself? Please let me know if you need clarification. Thanks!