PDA

View Full Version : Clear ComboBox



emailing
11-28-2007, 05:48 AM
Hi everybody. I have a UserForm that picks data from a table by selecting one data set via choosing the name of the data set in a combo box so that the accompanying data can be changed. If I change one data set with the OK button and want to change another one without closing and reopening the form I am able to clear the rest of the controls in the form, but not the combo box with which I select the data sets. Somebody any idea on that?? Hope the description of the problem was not too weird.

Bob Phillips
11-28-2007, 05:57 AM
ComboBox1.ListIndex = -1