Setting DataCombo to blank

[seema165]

Hi,

I want to clear the DataCombo that I have when the clear button is pressed.

I've been using the following code:

dataCombo.BoundText = ""

However, this is bringing up errors when I press the clear button, but it does clear the DataCombo box.

Any help will be appreciated.

 

[seema165]

Can anybody help with this??

 

[Foada]

Try this

Private Sub cmdClear_Click()
    DataCombo1.Text = vbNullString
    Set DataCombo1.RowSource = Nothing
End Sub

If you choose to battle wits with the witless be prepared to lose.

 

[BobRodes]

fyi, vbnullstring = "", in case you didn't know. Foada's telling you to use the text property instead of the boundtext property.

Bob