How to get sum of field from one form to another.

[sk1hotpepr]

I have a tabbed form that I want to be able to use information from one tab to populate a textbox on another tab. I have on the first form a listing of all contracts with their bid. The second form needs the sum of all contract bids shown. What is the best way to do this? I tried creating an textbox in the footer of the first form for the sum and set visible to "off" but am not sure of how to get that information over to the second form textbox. Any help would be greatly appreciated!

 

[jadams0173]

forms!form2!textbox=forms!form1!invisibletextbox

I think that will do it. Not 100% sure. The text box on form 2 should have its recordsource set to the above...I think.

Or either put the above in the on click event of a button on form 1 if that applies.

 

[Pampers]

hi sk1hotpepr
the tabed form doesn't influence the referencing. It all depends on the main form and its subforms. Take a look at the link, gives a good reference for referencing:

http://www.mvps.org/access/forms/frm0031.htm

Pampers.

You're never too young to learn

 

[sk1hotpepr]

Thanks for that link, it's a good one to keep for reference. I added that field to my query as a "sum" grouping which worked well without having to go through much coding. It was easier than trying to reference the field from a different tab. I'm not sure which is better performance-wise though. I'll have to try it both ways...

thanks again!

 

[Pampers]

i would think the sum in the query has a better performance, but that is just a thought.

Pampers.

You're never too young to learn