Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
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?
8/22/2022 - Mon
What do you mean by subform here?
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-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.
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent