+ Reply to Thread
Results 1 to 5 of 5

Option Buttons to Change ComboBox Values Dynamically

  1. #1
    Registered User
    Join Date
    03-21-2012
    Location
    Metro Manila, Phiippines
    MS-Off Ver
    Office 2007
    Posts
    77

    Option Buttons to Change ComboBox Values Dynamically

    Greetings!

    I made an automation to query service request number from our platform, I am having trouble with option buttons selecting and dynamically changing the combobox values. Can anyone help me revise the codes. Here is the scenario:

    I will click the Select SR Status Button then the form will appear, in the field "SR Worklist", there are two radio/option buttons to select, if I select the "CRG" button, the combobox below ("SR Owner") will change its contents dynamically, and if I select the "ICON" button, the contents of the combobox again will change. I am close to getting it but still I can't so I may need your help here. Thank you

    ESR Mining IX-7.0.xlsm
    "Consummatum Est"

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Option Buttons to Change ComboBox Values Dynamically

    Hi -

    You can put the combobox additem from your form initialize event to your option button click event

    Regards,
    Event

  3. #3
    Registered User
    Join Date
    03-21-2012
    Location
    Metro Manila, Phiippines
    MS-Off Ver
    Office 2007
    Posts
    77

    Re: Option Buttons to Change ComboBox Values Dynamically

    hello event21, I already tried that earlier, but unfortunately it doesn't work..

  4. #4
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Option Buttons to Change ComboBox Values Dynamically

    Hi -

    What error did you got?

    see here

    Regards,
    Event
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-21-2012
    Location
    Metro Manila, Phiippines
    MS-Off Ver
    Office 2007
    Posts
    77

    Re: Option Buttons to Change ComboBox Values Dynamically

    Well, I got no error though, its just the contents don't change as I select the other button, anyways, I have checked the one you did and I'm amazed that it's as simple as that, hehe. Thank you very much for your help. I really appreciate that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1