I have a query (MyQuery) that looks like this:
Select Field1, Field2, Field3, Field4 from My Table
When I run it directly, it correctly returns 4 columns of data.
I'm trying to display the query results in a subform on a main form.
When I do, only one column, namely Field4, of data is displaying
The source object of the subform is MyQuery
What am I doing wrong?