Thank you very much, it works perfectly.
May i ask you one more question, please?
i want to set the paid_until day automatically, only weekly & monthly changes, all other entries are for a full year.
I used in the lost focus event of date_paid the following code,
**************************************************
=IIf([Product_ID]="4",DateAdd("ww",1,[Paid_Until]),IIf([Product_ID]="5",DateAdd("m",1,[Paid_Until]),DateAdd("yyyy",1,[Paid_Until])))
************************************************************************
it does not work (4 is weekly, 5 is Monthly)
Thank you very much
Sepp
May i ask you one more question, please?
i want to set the paid_until day automatically, only weekly & monthly changes, all other entries are for a full year.
I used in the lost focus event of date_paid the following code,
**************************************************
=IIf([Product_ID]="4",DateAdd("ww",1,[Paid_Until]),IIf([Product_ID]="5",DateAdd("m",1,[Paid_Until]),DateAdd("yyyy",1,[Paid_Until])))
************************************************************************
it does not work (4 is weekly, 5 is Monthly)
Thank you very much
Sepp