>>Nadya. I've done all that. That's why I'm asking how to get them in the order that I want. Maybe I want the 3rd field in the first column, not include the 6th field and then who knows what else. I have done all the things as you have said and that's why I posted this. Because some syntax or something is not right. The table alias is available. It is full of records. I have all the columns control source set to the appropriate field. Is there something wrong wiht the syntax of the RecordSource? What else can I look for that would cause the grid not to populate? I woudn't have posted the information I did if I thought it worked.
>>
>
>The RecordSource must be 'myTableName'.
>
>Each column's ControlSource should be set up properly.
>
>Also verify each column's ColumnOrder to make sure fields are in the order you want them.
>
>That should be it.

The issue seemed to be that the ControlSource for each column needed to have the Alias removed. So,
"MyAlias.Field07" needed to be "Field07" instead. And the RecordSource was ok as "MyAlias" without a need for listing the fields. It works fine now.