Unbound field calculation save in table

  • Thread starter Thread starter sharrg2
  • Start date Start date
S

sharrg2

I have a score form that I created in Access 2003 the only part of the score
sheet I am interested in saving to the table is the total score. Because the
score sheet is all unbound fields and the total score is a control source
calculation how can I save the total score to a field in the table called
score.
 
sharrg2 said:
I have a score form that I created in Access 2003 the only part of the score
sheet I am interested in saving to the table is the total score. Because the
score sheet is all unbound fields and the total score is a control source
calculation how can I save the total score to a field in the table called
score.
Click to expand...


To do that, you need to calculate the total in a VBA
procedure. The procedure can then set the result to a bound
field or execute a query to save it to the table.

However, it is almost always better to save all the values
in the score sheet in a table and recalculate the total
whenever you want to display it on a form or report.
 
Marshall Barton said:
sharrg2 said:
I have a score form that I created in Access 2003 the only part of the score
sheet I am interested in saving to the table is the total score. Because the
score sheet is all unbound fields and the total score is a control source
calculation how can I save the total score to a field in the table called
score.
Click to expand...


To do that, you need to calculate the total in a VBA
procedure. The procedure can then set the result to a bound
field or execute a query to save it to the table.

However, it is almost always better to save all the values
in the score sheet in a table and recalculate the total
whenever you want to display it on a form or report.

--
Marsh
MVP [MS Access]
.
Thank you for the quick response
Click to expand...
There are so many fields on the score form that I do not need to save any of
the scores just the total. How would I wright a VB code for Score Total =
Score The Score is what I need to save in the table and that is the name of
the field that is bound.

Can you help on this I am not that great at getting VB Codes to work?
 
sharrg2 said:
There are so many fields on the score form that I do not need to save any of
the scores just the total. How would I wright a VB code for Score Total =
Score The Score is what I need to save in the table and that is the name of
the field that is bound.
Click to expand...

We need to translate the Score Total text box expression to
VBA code. I will have to see the expression before can try
to help translate it.

Is the form bound to the Scores table?

If not, how can we tell which record in the table should be
updated.

Or are we going to add the score as a new record? If so,
what other fields need to be in the new record and where do
these other field values come from.
 
Back
Top