Display info from 2 unrelated queries on 1 form

[Becker]

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.

[twinnyfo]

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.

[Becker]

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.

[Becker]

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.

[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!

[Becker]

Thanks! This is great. Starting from the subform wizard I don't get any options about where to put stuff. Thanks for your help.

[twinnyfo]

Glad I could help on this. Once you get the hang of subforms, they will become second nature!