June7
AWF VIP
- Local time
- Yesterday, 18:40
- Joined
- Mar 9, 2014
- Messages
- 6,135
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: