Help needed to move textbox value to field in table

[gostavee]

Hello
I'm trying to make an invoice form
everything is going great so far, but i have a problem driving me crazy
I have textbox in the subform footer of the invoice that gets the subtotal


and a textbox in the main form that gets the value of the textbox in the sub form
what i need is to move the value from the text box in the main form to it's field in the invoice table
i really really need to do that ..Thanks for the help
subform textbox name (subtot)
mainform textbox name (invtot)
table name (sale)
field name (invtot)
Thanks again

[June7]

Why are you saving an aggregate value? This should be calculated when needed.

[gostavee]

well i need it to calculate more fields in the table , and some times i need to know the total of a specific invoice so fast you know

[June7]

You can do this but be aware the saved value has risk of becoming 'out of sync' with the raw data. How does putting value in the table help to know total of invoice? Aren't you viewing data through form or report?

The code itself is simple:
Me!fieldname = Me.textboxname

The real trick is figuring out what event to put code into.

[gostavee]

i tried to put this in the textbox afterupdate in the main form and another time in the subform..didn't work :/ ..there is tax field in the table it's calculated field (access 2010) depends on the total inv and there is a totinv after tax another field in the table

Thanks for the help, but it didn't work..anyway to get around that ..can i use anything else to put the value of the inv total in the table ?

[June7]

Code is only way to save calculated data. Strongly recommend you not do this for aggregate data.

Try the form BeforeUpdate event.

[gostavee]

Ok thanks alot ..didn't work though , ok can you advise me how to get around that, let's say the customer not paying the total of his invoice you know what i mean

[June7]

Why didn't it work, what happened - error message, wrong results, nothing? It should work.

Get around what? Can calculate and view invoice total on form or report. Doesn't that give you what you need? What you do with the info is something else. What do you want to happen if customer not paying total of invoice?

[gostavee]

well nothing happening

[gostavee]

lets say this is the table (inv number..customer..inv total..customer amount paid..customer amount need to be paid (inv total-customer amount paid),,, see the whole table is calculated fields depends on (inv total)

[June7]

Don't think I would set up db like that.

I would have a table for customers (with CustAcctNum). Then Invoices table would be related to CustAcctNum. Then I would have a Receipts table which would also be related to CustAcctNum. Calculate difference of invoice totals and receipts totals for each CustAcctNum to determine account balance. But I've never tried to build an accounting system. I used QuickBooks.

[gostavee]

Yeah i love quick books but it's English only so we can't use it here :/

Here is the file

[June7]

There is no code in the db to analyse, can't even find embedded macros. Also, can't get past the language. Don't know names of fields and controls and 3 forms. So I can't even begin to write and test any code. Sorry, not able to help.

[gostavee]

Alright ..Thanks for trying