check number after update inserts date for following friday

[wrmedia]

having problems creating form action where when users enter a check number a date field is populated with the date of the following friday or that friday if they input on that day itself

thanx

 

[Remou]

Hi
This may help:
How to determine the First/Last day of a week
faq701-3103

 

[Eupher]

Hi, sorrentox,

Something like this in the check number field's After Update event:

Me![[blue]MyDateField[/blue]] = IIf(Weekday(Date(), vbFriday) = 1, Date(), Date() + (8 - Weekday(Date(), vbFriday)))

HTH,

Ken S.