G
Guest
I have a subform datasheet in which I enter a date and an odometer reading. A
VBA code runs in the background to calculate a) the partial miles since the
last entry date as well as b) the total miles accumulated since the very
first entry date.
My problem is that I can only get the partial and total miles fields to
update by closing and then reopening the form.
I am sure that there is a simple code like requery or refresh which can be
placed somewhere within the subform to calculate these fields automatically
as soon as the odometer data is entered ... only I am not smart enough to
figure out what command is needed and what event to attached it to. Can any
one help me?
VBA code runs in the background to calculate a) the partial miles since the
last entry date as well as b) the total miles accumulated since the very
first entry date.
My problem is that I can only get the partial and total miles fields to
update by closing and then reopening the form.
I am sure that there is a simple code like requery or refresh which can be
placed somewhere within the subform to calculate these fields automatically
as soon as the odometer data is entered ... only I am not smart enough to
figure out what command is needed and what event to attached it to. Can any
one help me?