By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,475 Members | 1,361 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,475 IT Pros & Developers. It's quick & easy.

Display info from 2 unrelated queries on 1 form

P: 54
I have a form that I would like to have display 2 unrelated sets of data. Right now it displays one from "finish query" by filtering based on what value is typed into a textbox. The record source is set to this query already. Now I would like to add an area to the side of this data where "hood query" can be displayed by typing the hood number into a text box. Thanks for everybody helping a noob to learn access.
Jul 26 '12 #1

✓ answered by twinnyfo

Becker,

You actually are much closer to your answer than you might think....

Create a new form, based on the record source that you want. When you save it, instead of saving it as "frmFormName" call it "fsubFormName" so you know that it is a subform. Then, from the main form in design view, you can either use the subform wizard in Access or simply drag and drop the subform onto the main form. This might depend on your version of Access.

This "should" do the trick.....

I think once you get the hang of subforms, you may find that you will use them all the time!

Cheers!

Share this Question
Share on Google+
6 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,045
Becker,

This can be done very simply by creating a subform, which has the record source of this other query, based on the text box info you gather.

Then embed that subform on the main form and you will have both sets of data. The subform's data will be controlled by the text box while the main form's data is still controlled by its own record source.

If the data were related, you could have the subform show data that was relevant to the main form's data, also. Just depends on what data you have and how unrelated it truly is.

Let me know if there is more I can help with.

Warmest regards.
Jul 26 '12 #2

P: 54
I apologize, I should have explained this in my original post as well. I have tried a subform already, and I may just not understand their capabilities well, but it seems to show only in a format that looks just like a table or query would. Is there any way to be able to design a subform like I would a main form. I need to put certain fields in certain places and based upon a user's entry in some fields others should give back an answer based on a mathematical computation.
Jul 26 '12 #3

P: 54
Also I need certain fields to visible only at certain times. I know how to do this in a regular form, but I cannot find a way to do this on a subform.
Jul 26 '12 #4

twinnyfo
Expert Mod 2.5K+
P: 3,045
Becker,

You actually are much closer to your answer than you might think....

Create a new form, based on the record source that you want. When you save it, instead of saving it as "frmFormName" call it "fsubFormName" so you know that it is a subform. Then, from the main form in design view, you can either use the subform wizard in Access or simply drag and drop the subform onto the main form. This might depend on your version of Access.

This "should" do the trick.....

I think once you get the hang of subforms, you may find that you will use them all the time!

Cheers!
Jul 26 '12 #5

P: 54
Thanks! This is great. Starting from the subform wizard I don't get any options about where to put stuff. Thanks for your help.
Jul 26 '12 #6

twinnyfo
Expert Mod 2.5K+
P: 3,045
Glad I could help on this. Once you get the hang of subforms, they will become second nature!
Jul 27 '12 #7

Post your reply

Sign in to post your reply or Sign up for a free account.