You already have a macro called SystemOutage. You can't figure out why the
form is opening regardless of which combobox item you choose. The next step
is to try to figure out what value the macro thinks is selected in
Forms![Requests]![Subcategory]. The simplest way to do this is to open your
macro in design view, insert a line above your OpenForm action and put in a
MsgBox action. In the Message property (down below), put in this:
=[Forms]![Requests]![Subcategory]
Make sure to include the equal sign.
This will display a msgbox that tells you what the macro sees as the value
of that combobox. It will help you debug why it's opening the form regardless
of what's selected.
Barry
Jenn said:
I realize I'm a little dense on this, but I'm not following what you
mean?
Thanks!
Barry Gilbert wrote:
You can debug this a little by putting a message box before this line in the
macro. Have the messagebox display the value of your combobox. This should
tell you a little more about what's going on.
Barry
:
Okay I got a little further. I have a macro called SystemOutage which
does the following:
Action: OpenForm
Form Name: System Outage Alert
Where condition: This is what I can't figure out. I tried
Forms![Requests]![Subcategory] = "System Outage" however this doesn't
show just when System Outage is selected in the Subcategory combo, it
shows no matter what is selected in the combo.
Thanks again!
Jenn wrote:
I need help opening my System Outage Alert Form when System Outage is
selected from my combo box called Subcategory. Any help would be
appreciated. I'm having a hard time figuring this out and I'm a very
inexperienced user.
Thank you!