Solved INSERT INTO NOT WORKIG

[Sepp1945]

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

 

[Uncle Gizmo]

Giz, "internet" into ?

Typo corrected. Thanks for the heads up. .

 

[June7]

Product_ID is a number type so don't put parameter in quote marks. Need to specify field to save value into. Consider:

Me!ProductValue = DateAdd(Switch([Product_ID = 4,"ww", [Product_ID=5,"m", True,"yyyy"), 1, [Paid_Until])