I have a form with a txt box called length_stay whose control source is:
=DateDiff("d",[DOA],[DOD])+1
where DOA and DOD refer to date fields on the form.
this part works fine.
now, if the number that is returned is <=3 then I want another field on this form called LBPATH to =7.
I went to the AfterUpdate Event and said:
If length_stay <=3 then
LBPATH = 7
end if
but this doesn't work... I also tried the BeforeUpdate.. no luck.
=DateDiff("d",[DOA],[DOD])+1
where DOA and DOD refer to date fields on the form.
this part works fine.
now, if the number that is returned is <=3 then I want another field on this form called LBPATH to =7.
I went to the AfterUpdate Event and said:
If length_stay <=3 then
LBPATH = 7
end if
but this doesn't work... I also tried the BeforeUpdate.. no luck.