Experts:
I need some assistance with (I think) a relatively easy problem. Below summarizes what I have in an Access database and what I'd like to accomplish:
- I have a form with a listbox "ListBoxActions1"
- Listbox "ListBoxActions1" shows eight values upon opening the form.
- First value = "All"; remaining seven values indicate a specific category.
- If "All" is selected, I want to enter the IF clause. If values <> "All", I want to enter the "Else" clause. Below is the pseudo code:
Code:
If ListBoxActions1 = "All"
Do something
Else (that is, value <> "All")
Do something else
End If
What does the IF statement look like to ensure "All" is properly executed? Right now, when I select "All", I enter the "Else" statement (vs. the IF).
Thank you,
EEH