Is it possible to have 2 queries opened in a form and using a row from the 1st to update the 2nd?

[Stanislavnba]

I have a form with a couple subforms that update based on the data shown in the form, which is taken from a query.


My problem is that I cant see all the rows simultaneously from the main query and I need to press next record every single time to get to where I want or just to browse all of the records.
Is it possible to have the main query visible like a table or a report and when I select a row the rest of my subform queries update?

[Bob Fitz]

Can you post a copy of the db with just a few dummy records so hat we might understand a little better

[Stanislavnba]

Here's a simple example. I have a table customers and I have a table with orders and a bunch of other things. Let's say, I want from my customers table to have a query with just the names of the customers who ordered something in the last one month. In another query to see which of these customers ordered what? And I want this done by selecting the row with the customer and my other query updating and showing me this customer ordered this items.

[ArviLaanemets]

I have a form with a couple subforms that update based on the data shown in the form, which is taken from a query.
My problem is that I cant see all the rows simultaneously from the main query and I need to press next record every single time to get to where I want or just to browse all of the records.
Is it possible to have the main query visible like a table or a report and when I select a row the rest of my subform queries update?

Place your current main form (designed as continuous one) as subform into unbound form (no need to link it to anything). In unbound form have a hidden unbound text box. Create an OnCurrent event for this continuous form, which updates the hidden textbox in unbound form with current value of PK in your (previously main) form;
Add your another form (your previous subform of your previous main form) into same unbound form as second continuous subform. Instead of linking it to PK of your another form, link it to hidden unbound text box in unbound form.

In case you need several forms to be linked to your now continous main form, and it will be crowded in unbound form, you can have a tab control in your unbound form, and place all forms (or all linked subforms) into pages of this tab control.

[Stanislavnba]

Place your current main form (designed as continuous one) as subform into unbound form (no need to link it to anything). In unbound form have a hidden unbound text box. Create an OnCurrent event for this continuous form, which updates the hidden textbox in unbound form with current value of PK in your (previously main) form;
Add your another form (your previous subform of your previous main form) into same unbound form as second continuous subform. Instead of linking it to PK of your another form, link it to hidden unbound text box in unbound form.

In case you need several forms to be linked to your now continous main form, and it will be crowded in unbound form, you can have a tab control in your unbound form, and place all forms (or all linked subforms) into pages of this tab control.

Thank you! That worked out great.