P
Pavithra
I have a combo box for which the Rowsource type is a
Query.In the After_update event of the cobobox, I call a
macro, that performs a find_record based on the value
chosen in the combo box. When I type some invalid value
in the combo box I get the message "the text you entered
is not an item in the list". This is fine. But when I
enter empty value in the combo box, it gives me a system
error saying that the Find action in the macro fails
because of the null value.
Is there any property that i can change for the combo box
such that I get the same error message as the one that i
get for the invalid value. I want to use any of the
property of the combo box to do this rather than make a
code change since the no of objects is very high.
Thanks
Query.In the After_update event of the cobobox, I call a
macro, that performs a find_record based on the value
chosen in the combo box. When I type some invalid value
in the combo box I get the message "the text you entered
is not an item in the list". This is fine. But when I
enter empty value in the combo box, it gives me a system
error saying that the Find action in the macro fails
because of the null value.
Is there any property that i can change for the combo box
such that I get the same error message as the one that i
get for the invalid value. I want to use any of the
property of the combo box to do this rather than make a
code change since the no of objects is very high.
Thanks