Refreshing Unbound fields on a Continuous Form

R

Rudy

I have a continuous form that displays the birthday of each contact. I
want to calculate the person's age when going from record to record. I
have used a function I found within this newsgroup to calculate the age
and used the AfterUpdate Event to initiall populate for a new record or
when the birthday changes.

The problem...when moving from record to record, the age field (unbound
field) does not recalculate. How do I solve this?
 
D

Douglas J. Steele

Try putting the function in the Current event, as well as the AfterUpdate
event.
 
M

Marshall Barton

Rudy said:
I have a continuous form that displays the birthday of each contact. I
want to calculate the person's age when going from record to record. I
have used a function I found within this newsgroup to calculate the age
and used the AfterUpdate Event to initiall populate for a new record or
when the birthday changes.

The problem...when moving from record to record, the age field (unbound
field) does not recalculate. How do I solve this?
Click to expand...


Call the function in the age text box's Control Source
expression, no code needed.
 
Top