Solved INSERT INTO NOT WORKIG

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])
 
Last edited:

Users who are viewing this thread

Back
Top Bottom