Insert calculated value from a form into the Table

Robby_1969

New member
Local time
Today, 06:27
Joined
Dec 13, 2012
Messages
2
Dear all,
I am new to this Forum (also to access), so congratulations to all those unselfish people who give so much help.

My Problem:
I have a Form and a TextBox which is connected to one entry in the table (currency data type). Further in the same form I have a Subform which calculates a value based on some user entries. The result of this calculation I like to save into the table which is connected to the TextBox. I do not know how to do this. The TextBox allows only some Default Value, and this must be a constant. How to transfer the calculated value from another TextBox (calculated field) to the other TextBox which is connected to the Table?

Appreciate your Help
Regards
Robby
 
Store calculated value in one variable.
 
all you should have to do is bound the text box to the table field this can simply be done by selecting the text box while the form is in design view going to the data tab and next to the Control Sourse you should see a ... box click it and find the table and field that apply.
 
Guys you miseunderstood me.
As I explained, one TextBox is connected to a field in the Table (via Vontrol Source Property). The other TextField calculates a value also via the Control Source property. So how to bring the calculated value from the Textfield into the table?
 

Users who are viewing this thread

Back
Top Bottom