G
Guest
Hello,
I have aged failed in a table that get initialize during initial data load.
I would like for this field to increase by one each day goes by. This field
is locked on the form level.
The initial code for loading the field as follow:
Aged = DateDiff("d",[Date On File],Date())
I have tried to update this automatically on the form level by:
On Enter: Me.[Aged]= DateDiff("d",[Date On File],Date())
Or
On load: Me.[Aged]= DateDiff("d",[Date On File],Date())
Or
Before update: Me.[Aged]= DateDiff("d",[Date On File],Date())
I have Un-locked the field and re-try the above codes, but no auto
update…………..
Regards
I have aged failed in a table that get initialize during initial data load.
I would like for this field to increase by one each day goes by. This field
is locked on the form level.
The initial code for loading the field as follow:
Aged = DateDiff("d",[Date On File],Date())
I have tried to update this automatically on the form level by:
On Enter: Me.[Aged]= DateDiff("d",[Date On File],Date())
Or
On load: Me.[Aged]= DateDiff("d",[Date On File],Date())
Or
Before update: Me.[Aged]= DateDiff("d",[Date On File],Date())
I have Un-locked the field and re-try the above codes, but no auto
update…………..
Regards