Clearing a Read-Only Combo Box

[BrianW]

I have created a form that uses various SQL calls (using ADODB) to populate combo boxes depending on users input. Once the form is completed, all elements are cleared for the inputing of new data. When I try to clear the Combo Boxes, I get a Run-Time 383 "Text is a read-only property." Is there any other way to return to a blank Combo?
Tia

Cloning is the sincerest form of flattery

[Cakkie]

If the Combo-box is linked to a field in a table of the database using the datasource property, try to unset the datasource property, and then use the refresh method.

Tom Cannaerts
slisse@planetinternet.be

The best way to escape a problem, is to solve it.

[Lothar Haensler]

to clear a combobox or listbox use the Clear method.