how to clear values in dropdownbox

[paritosh_a]

How can i clear the values in the combobox when some event occurs ?
i searched this everywhere but no solution found.

 

[GUIDO22]

Simply set the recordsource property in whichever event you wish to use, to empty string
ie.
cboCombo.Recordsource=""

 

[paritosh_a]

showing compile error

Its showing compile error:
data or member not found.

I am using MS Access 2002.combobox does not support this property.
Please suggest

 

[GUIDO22]

I do not have Access 2002 - but check your online help and see if the Recordsource property can be accessed at runtime - seems strange that a later version of Access does not when earlier versions (Access '97) does...????

 

[paritosh_a]

didnt get any help

i didnt get any help in ms access to clear combobox.
please help

 

[RuralGuy]

How about Me.ComboBoxName.Undo