My problem is this; I am trying to put together an email order form for a product range. There are certain product dependencies giving me problems, for example:
- if you order 2 x Product A, you will need 2 x Product C (but not product D)
- if you order 2 x Product B, you will need 2 x Product D (but not Product C), etc.
What I would like to do is have an alert popup if the user orders both Product C and Product D but the only place I can think to put the data validation is already being used as a list.
My apologies if this doesn't make sense but I am getting ready to put keyboard through my monitor.
(Please be gentle, I know little to no VB)