Avatar of Jenkins
JenkinsFlag for United States of America asked on

Query results not displaying correctly in subform

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?
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon

What do you mean by subform here?
Dale Fye

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

I had originally created a subform that was displaying the entire contents of a table. I then attempted to change it to display the results of a query instead by changing the source object in the subform's properties window.  The query runs against the same table as was originally displayed in the textbox.

The table only has 4 fields.  But instead of displaying the entire table, I (eventually) want to display query results so they I can limit the number of records that get displayed.  

As a starting step, all I was trying to do at this point was to select all of the records from the table and have them display in the subform.  Just to see if I could get the query results to display. So actually, if it was working the way I want it to, the query results should be displaying exactly as if I was displaying the table directly since I'm selecting all records in the query.  I still have to read through everything you experts wrote, so I'll try to work it out and post again.

OK. Got it working.  Thanks.
Your help has saved me hundreds of hours of internet surfing.