Transfere Text to different Text Box

[jlclark4]

Hey.



I have a text box that has a formula in it to calculate a percentage. Is there a code I can use to transfer that Percentage to another text box in the same entry? I want to use VB so I can set the control to a table to record the percentage...

Thanks

[RuralGuy]

Normally we do not store calculated values in tables. Can it be calculated in a query from values in a table?

[jlclark4]

Yeah, I know. My query isnt giving me a Totals option. Plus, the table is very complex and my form uses Tabs. So not all of the controls have values in them for each entry. They very. And so does the total number divided by....If there was a way to just transfer the percent to the table it would be the easiest and get the job done since that number will never change...any suggestions?

[RuralGuy]

When the Form is doing the calculating there is no event that could reliably move the results unless the user is making other changes that need saving. If the later is true then you can use the BeforeUpdate event of the form to store the calculated value.