Query data to show up on Form

[SteveGr]

Hi all,

How do I get the query results to show on my form. I tried using a subform but the layout wasn't what I wanted so I thought to use individual text boxes to rearrange them to suit me. But not sure how to send the query info to the text boxes on my form.

Thanks, Steve

 

[skwilliams]

Is the query your forms record source?

 

[SteveGr]

If I understand the question. . . No the records are already in a table that I am querying.

 

[skwilliams]

If you want your query to populate a form, you need to set the form's record source to the query.

Open the form in design view and click the properties button on the toolbar. Select the query name from the drop down list in record source.

The query will pull it's information from the table and in turn populate the form.

Does this answer your question?

 

[SteveGr]

I understand what you mean. But when I change the record source on the form to my query, a blank form shows up when I switch to Form view for some reason. when I remove the record source, all my controls are viewable again on my Form.
Any ideas

Thanks, Steve

 

[skwilliams]

If you would like to post the db, I'd be happy to look at it for you.

 

[SteveGr]

The database is too big for this Forum.

It's around 8 meg

 

[skwilliams]

You can email it to me at skwilliams@mcphersons.com

 

[SteveGr]

Will your email handle that size?

 

[skwilliams]

Hopefully, we'll try it.

 

[SteveGr]

Never mind, I think I got it.
I had to use a blank form without the combo boxes that I was using for setting the query criterea.
Thanks for you help!
Stevegr

 

[SteveGr]

SKWilliams,
I thought I had it but I guess I didn't
I emailed you the database.

 

[skwilliams]

I'll look at it as soon as it finishes downloading.

 

[skwilliams]

Are you trying to display the results of the query in Form1 or Form2.

 

[skwilliams]

Also, which query are you using to get your results?

 

[SteveGr]

At first I had only Form 1 but split it into 2 forms because I thought that was my problem.
I am trying to query info from the "qryKBAPressData" and have it displayed on a form once I select criteria from the combo boxes.

 

[skwilliams]

Your query will not open. I receive a "failure to create file" error. The query appears to be corrupt. You may need to recreate the query.