I am trying to do a calculation inside my form and have access output the answer to this equation into a table i have created. To do my calculation i have 3 fields in my form. The first one pulls a constant from my tables, the second one is a quantity entered by the user and the third field is the answer of the equation. I am trying to have access send this final value to a spot in my table.
The only thing i can think of is using the "AfterUpdat e" Event under the field's properties but i do not know what equation or code to put in there to get access to send this value back to my table.
Can anyone help?
The only thing i can think of is using the "AfterUpdat e" Event under the field's properties but i do not know what equation or code to put in there to get access to send this value back to my table.
Can anyone help?
Comment