June7
AWF VIP
- Local time
- Today, 00:10
- Joined
- Mar 9, 2014
- Messages
- 6,122
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])
Me!ProductValue = DateAdd(Switch([Product_ID = 4,"ww", [Product_ID=5,"m", True,"yyyy"), 1, [Paid_Until])
Last edited: