Passing data from one FORM to another FORM

[sud2017]

Hi Expert,

Reposting from my other post/forum with more details as the original question was unanswered possibly due to lack of details.



Below Image 1 is my main form, and Image 2 is my subform. I need the RED circled textbox VALUE from the subform (image 2) to be PASSED on to the RED circled textbox in my main form (image 1). Both forms are unrelated. This might be an easy fix but I'm struggling for quite sometime and need to fix to meet my project deadline. Any help will be much appreciated.

IMAGE 1 - Main FORM


IMAGE 2 - SUBFORM

[June7]

Why do you need to do this? What expression is in the main form textbox ControlSource?

Referencing subform controls and fields must be done by referencing the subform container control. Advise naming the control different from the object it holds, like ctrWork. Then expression like:

=[ctrWork].Form.[control name]

or

=[ctrWork]![field name]

[sud2017]

The reason I want to do this is because the MAIN FORM provides me the TOTAL COST of the PROJECT and the subforms perform the component-wise cost estimation for various components of the Project.

Expression in the Main Form ControlSource is =form!WC1F1!Text15

WC1F1 is name of my subform and Text15 is the textbox where I want the data to come from to the Main Form.

I didn't quite understood the container control you suggested so any further direction would be appreciated. Thank you!

[June7]

A subform/subreport is created by installing a subform/subreport container control on a form. The container has SourceObject property which can reference a table, query, form, or report. Just like other controls (textbox, combobox, etc) the container has a Name property.

But do you not really have a form/subform arrangement? Is your 'subform' really just a form that is opened independently?

Are you trying to save this Total to a field? Shouldn't. The value should be calculated when needed.

[sud2017]

Thanks for the clarification June7. I don't have a form/subform arrangement and my subform is just a form that is opened independently. All I need is that the value for COST from the subforms to be passed on to my MAIN FORM, where I can calculate the SUM of all COMPONENTS COSTS that's coming from subforms and print a report for user from Main Form.

I feel like it should be fairly simple but I am beginner in Access so not sure how to do it.

A subform/subreport is created by installing a subform/subreport container control on a form. The container has SourceObject property which can reference a table, query, form, or report. Just like other controls (textbox, combobox, etc) the container has a Name property.

But do you not really have a form/subform arrangement? Is your 'subform' really just a form that is opened independently?

Are you trying to save this Total to a field? Shouldn't. The value should be calculated when needed.

[June7]

Are you trying to print the form? Forms are intended for screen display. Reports are intended for print output. Each can be made to work somewhat like the other but not as effectively.

As I stated, calculate the Total when needed. It is not necessary to display on main form. Do this calculation in query or report design.

The expression you tried requires the 'subform' to remain open. And slight error in your syntax, should be: Forms!WC1F1!Text15

[sud2017]

Thanks again for the insight. When performing calculations in a query or report design, it only allows me to choose the TABLE or QUERY where the data will come from, but I want the data to come from a TEXTBOX from a FORM. The value that is calculated in this TEXBOX is not stored in any TABLE or QUERY.

In my report, I want the COST data to come from the subforms. Kindly advise.

Are you trying to print the form? Forms are intended for screen display. Reports are intended for print output. Each can be made to work somewhat like the other but not as effectively.

As I stated, calculate the Total when needed. It is not necessary to display on main form. Do this calculation in query or report design.

The expression you tried requires the 'subform' to remain open. And slight error in your syntax, should be: Forms!WC1F1!Text15

[June7]

And it should not be stored, it should be calculated - in query or textbox.

Use report Sorting and Grouping features with aggregate calcs in form and group header/footer sections. Report allows display of detail data as well as summary calculations.

Open report with filter criteria applied as appropriate for your desired output.

[sud2017]

Ok. I'll have to explore these features of REPORTS. Hopefully it allow me to perform and display the summary calculation based on the components costing values from different subforms. I will post you as I make some progress with this. Thanks so much again for your time.

And it should not be stored, it should be calculated - in query or textbox.

Use report Sorting and Grouping features with aggregate calcs in form and group header/footer sections. Report allows display of detail data as well as summary calculations.

Open report with filter criteria applied as appropriate for your desired output.

[June7]

Might need subreports.

Expression in textbox on report can reference the open 'subform' textbox.

VBA code behind 'subform' can set value in textbox on 'main' form before the 'subform' closes.

[sud2017]

Could you recommend any tutorial/video on how I can perform summary calculation in a REPORT from the data that's from TEXTBOX of FORMS and not from any TABLE OR QUERY. All links I could find online only talk about using records from TABLE/QUERY. Thank you again for your time.

And it should not be stored, it should be calculated - in query or textbox.

Use report Sorting and Grouping features with aggregate calcs in form and group header/footer sections. Report allows display of detail data as well as summary calculations.

Open report with filter criteria applied as appropriate for your desired output.

[June7]

Cannot do 'summary' calc of data from form textbox. The report textbox can reference a textbox on form using the same expression you posted earlier - as corrected in post 6.

[sud2017]

I am hoping that when the COST is calculated in subform, and I SAVE and CLOSE the FORM, it will pass that calculated value to Main Form or Report in order to perform a summary calculation with other COSTS that's coming from other subforms. I never thought this will be so difficult in ACCESS or possibly I'm not on right track

Might need subreports.

Expression in textbox on report can reference the open 'subform' textbox.

VBA code behind 'subform' can set value in textbox on 'main' form before the 'subform' closes.

[June7]

As already stated, code in subform can set value in main textbox before the subform closes.

Or leave the subform open and report textbox references subform textbox.

What is 'right' is what works for you although a purist might say the 'right' track is to calculate the total in report design, which is usually quite simple but I don't know enough about your db structure.

[sud2017]

Thanks very much. I am now able to get the text box values from the subforms to the REPORT and also can perform summary calc. However, one issue I have is that the forms should remain open. I will have over 8-10 subforms for components costing and if the user keeps all the forms open after performing estimation, it might be bit frustrating to them. Is there a way that I can save and close the form and then when I open the report the values still show up. I very highly appreciate for your time.

Cannot do 'summary' calc of data from form textbox. The report textbox can reference a textbox on form using the same expression you posted earlier - as corrected in post 6.