Calculated Field on a form

M

mikelee101

Hello,
I have a form, bound to a table, with a calculated field on it. This
particular field displays the last date that data is contained in the table
for. The control source is:

=Max([tblActiveData]![Expiration])

This works fine but, as the table gets larger, it takes longer and longer
for the field to calculate when the form is opened. It's now over a minute
and a half, which seems like an eternity when you can't do anything. I'm
looking for another way to accomplish this, but without the long calculation
time. I've tried writing the date to a separate table, but I get "#NAME?" in
the field when I try to use a record from a table other than the table the
form is bound to.

Any suggestions would be greatly appreciated.

Thanks to all.
 
Top