K
Keypad
Hi,
Using VB code, how do I use Select Case to do an action if a text string
exists in a field within a table. For example, I have a combo box named
DrinkTypes bound to a table named MixedDrinks:
Table name = MixedDrinks
Drink_ID PK
Drinks Type = Text
I want to test for text strings like "Martini, Bloody Mary, etc" using
Select Case then open a MsgBox with mixing instructions for that particular
drink. How do I code something like this in Access?
Thank you in advance!
Using VB code, how do I use Select Case to do an action if a text string
exists in a field within a table. For example, I have a combo box named
DrinkTypes bound to a table named MixedDrinks:
Table name = MixedDrinks
Drink_ID PK
Drinks Type = Text
I want to test for text strings like "Martini, Bloody Mary, etc" using
Select Case then open a MsgBox with mixing instructions for that particular
drink. How do I code something like this in Access?
Thank you in advance!