J
Johnny
I have two combo boxes. If one combo box criteria is selected, I have it set
to clear the second combo box: ex..ME!cbxWCNum = "" when cbxClasscode is
selected. Works fine in the form. However, when printing a report based on
the combo boxes I want a message box to come up indicating I have not
selected a criteria for my selection (WCNum or Classcode). Each one is a
separate report and separate button selection. This works fine the first
time into the form, but if I jump back and forth between the two combo boxes
and have not closed/reponed the form, I do not get the message box. I just
get a blank report for the combo that happens to be blank. I want a message
box every time a particular combo is blank and the associated report is
selected without having to close the report and go back in. Any suggestions
as to what to add to my coding please?
to clear the second combo box: ex..ME!cbxWCNum = "" when cbxClasscode is
selected. Works fine in the form. However, when printing a report based on
the combo boxes I want a message box to come up indicating I have not
selected a criteria for my selection (WCNum or Classcode). Each one is a
separate report and separate button selection. This works fine the first
time into the form, but if I jump back and forth between the two combo boxes
and have not closed/reponed the form, I do not get the message box. I just
get a blank report for the combo that happens to be blank. I want a message
box every time a particular combo is blank and the associated report is
selected without having to close the report and go back in. Any suggestions
as to what to add to my coding please?