Counting in subform

[aubrey]

Hello All,

I have a Form that has a subform. I have a text box on the subform the
counts the number of records using a formula. I have another text box on the
main Form the text box on the subform as its Control Source. The problems is
that not only do I new this number to display on the main form but I also
need to have that information be saved in the table, since the Control Source
merely refers to the text box on the subform that number does not get saved.

I have tried sever different ways of trying to get this data back to my
table including, having a two text boxes on the main form, one with a Control
Source as a field from my table and running a BeforeUpdate or OnCurrent
procedure; something like "me.textbox1 =me.textbox2" Nothing seems to work.

If someone can point me in the right direction that would be great.

Thanks,

 

[Wayne-I-M]

If you "really" want to save a calculation then you could bind the control on
the main form to a table. Use setvalue to provide the data from the sub form.