>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.
If it's not broken, fix it until it is.
My Blog