Form datasheet view, column order is mixed up. Need help to determine why column order is not right

Hello there,

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!
lchaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
set the Tab index according to what you need to see
First column must have tab index=0, next will be tab index 1
tygrus2Commented:
In datasheet view, click on the column names and drag them into a different order. Save on close.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lchaAuthor Commented:
the tab index for each control are in order 0, 1,2,3,4,5 from top down

I tried clicking on the column names and dragging them to the correct order and this did what i needed.  thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.