>When I do it that way it works fine, but I dont want to use the grids' RecordSource property, instead I want to use the Columns' ControlSource Property
>so that I can display specific fields instead of all.

It's up to you to set Grid.ColumnCount and Column.Controlsource properties after you set Recordsource property.