I use the following code clear a combo box and a text box. Problem is that it works great apart from when initialising the form on the First Question sometimes. Is there another method that may be more reliable? Call Question_load txtInput.Value = "" cmbOptions.Value = "" 'Fix to Clear Combo Box Prior to New Question Load cmdNext.Enabled = (m_Response <> "") CmdPrevQuestion.Enabled = True

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Clearing field

Thread starter trsisko
Start date Jun 30, 2008

trsisko

Board Regular

Jun 30, 2008

I use the following code clear a combo box and a text box. Problem is that it works great apart from when initialising the form on the First Question sometimes. Is there another method that may be more reliable?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com

ffice

ffice" /><o

></o

Code:

  Call Question_load
    txtInput.Value = ""
    [B]cmbOptions.Value = ""[/B] 'Fix to Clear Combo Box Prior to New Question Load
    cmdNext.Enabled = (m_Response <> "")
    CmdPrevQuestion.Enabled = True