You mean RecordSourceType: 4 - SQL Statement ?

>>How can I specify what fields to show in the gird (ColumnCount: -1), since the rest of the fields would be above it in all the textboxes for add/editing.
>
>You can use SQL Select as a RecordSource that only selects the fields you want. OTherwise, you'll have to build the columns either in the designer, or from a table, ect.