Link a calculated form field to a table field

[ajhts]

I have three fields on my data entry form:

AMinutes BMinutes TxMinutes

I have the txminutes field automatically add the aminutes and the bminutes together as they enter the data so that they can see the total immediately. I want the result from the txminutes field to be permanent in the table storing all of the data. I assume that it is a child link of some kind, but I can't figure it out.

When I view the table, I see all of the other fields but the txminutes is blank because it didn't link or populate.

Thanks,
AJ

 

[ajhts]

I forget to say that my form is from a data entry query that when they enter the facility number is pops up with the facility name so they know they have selected the correct facility number. I don't know if this matters about linking a field back to the table.

 

[PHV]

It's often a bad idea to store derived/calculated values in a database.
The usual way is to do the calculation in a query and thus get always accurate values.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[traingamer]

If it is a calculated field, there is typically no good reason to store the value. Just recalculate it each time you need to see it.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[ajhts]

heres the problem, the sheet that comes in for data entry is not totaled for her. She has two options, use a calculator to add aminutes and bminutes together, then add that result into the txminutes field. Or, what I would like to do is let her data entry form be her calculator and save the result of the aminutes plus bminutes in the txminutes field in the table. Is this possible. I hope that I explained my dilema.

Thanks,
AJ

 

[TheAceMan1]

How are ya ajhts . . . . .

Controls on forms are [blue]not Linked[/blue] to table fields. They are [blue]Bound[/blue]. Meaning, the [blue]ControlSource[/blue] of a control is prescribed by a [blue]fieldname[/blue]. [purple]Linking is involved with Table Relationships.[/purple]

As already stated by [blue]PHV[/blue] & [blue]traingamer[/blue], not a good Idea storing calculations in a table. There are unique instances (such as in banking statements, where a previous balance is carried forward) but they are rare.

See Ya! . . . . . .