Hello, Good morning!
I am hoping someone can please help me with an after Update problem I am having within a form in an Access 2016 database.
I have a textbox (TextboxA1) that I would like to populate based on criteria firstly within a textbox and secondly in a dropdown list, but only if both criteria are met.
Data Source 1. (Text Box)
Within another text box there are various coma separated values, for example;
Wool Jumpers, Cotton T Shirts, Trousers,
Data Source 2. (Drop Down List)
List of 4 options;
1. (Blank - Empty cell, No Contents)
2. Small
3. Medium
4. Large
Examples of a Query
If "Wool Jumpers" is contained anywhere in Source 1. AND Source 2. is "Small" - Show "Wool Jumpers Small" in the TextboxA1
If "Wool Jumpers" is contained anywhere in Source 1. AND Source 2. is "Large" - Show Wool Jumpers Large" in the TextboxA1
If "Wool Jumpers" is Contained anywhere in Source 1. And Source 2. is Blank - Empty Cell, No Contents - Show nothing (remain blank) in TextboxA1
If "Wool Jumpers" is NOT contained anywhere in Source1. AND Source 2. is "Large" - Empty Cell, No Contents - Show nothing (remain blank) in TextboxA1. (Both criteria must be met to show a result)
If the criteria is met and shows but then either of the sources are changed to not satisfy the requirements then the TextboxA1 is again blank.
I hope I have explained this clearly.
May I also thank you in advance for any assistance you can offer.
many thanks