I am using one single combo box to display two different drop down lists. I do this by alternately assigning to its RowSource two different SQL statements, and then issuing the Dropdown method. It works fine. The problem is that as each dropdown list opens up, the cbo’s text box continues to display the selection from the previous dropdown list making a confusing looking picture.
I would like the cbo’s text box to be blanked out as each succeeding list is opened. I have tried assigning a zero length string to the cbo’s Value and Text properties in both its Entry and BeforeUpdate events but in all cases received the illogical error message “Run-Time error ‘2115’: The macro or function set to the BeforeUpdate or ValidationRule property for this field is preventing (Access) from saving the data in the field.”
Is there a way to blank out the cbo’s text box when dropping down a new list?
Thanks.
