access vba code for separating lists
Posted on 2013-01-25
I have a text field which causes a lookup from a list;
eg the list is apples, oranges, pears, grapes.
What I want to do is make a report out of that list so that:
if the chosen list item is oranges, the report is able to make a list of the other items in the list.
How this would work:
The Report would say "Thank you for buying Oranges"
"you are now entitled to a discount against:
apples, pears, and grapes
So its a question of how the list can be split to display the exceptions.