Value in Footer not accessable

  • Thread starter Thread starter Bill Sturdevant
  • Start date Start date
B

Bill Sturdevant

I have a form which displays all the records in a table.
One of the fields contains numeric values and is
named "Counts".

In the form footer, I have a field called "Counts_Total"
with the Control Source set to "=Sum([Counts])". The
value displayed here is the sum of the field Counts in all
the records. It works.

However, in my Form_Open logic I reference the value of
Counts_Total, but it is empty. It is almost as if the
Form_Open is querying the field too soon.

What can I do?
 
However, in my Form_Open logic I reference the value of
Counts_Total, but it is empty. It is almost as if the
Form_Open is querying the field too soon.
Click to expand...

It is. Form_Open executes BEFORE the controls in the form have been
populated.

Use the Form's Load event instead.
 
Back
Top