+ Reply to Thread
Results 1 to 2 of 2

Requery a combo box

  1. #1
    Registered User
    Join Date
    08-03-2017
    Location
    london
    MS-Off Ver
    2016
    Posts
    1

    Requery a combo box

    Hello,

    I have a problem with a user form. There are two combo boxes, the second combo box list is populated with different values based on the selection on the first combo box.

    The problem is once you've made a selection in the first combo box - if you change your mind and select another option the second combo box doesn't update with the new values. You have to close then open the user form to reset the comobo boxes.

    Any help would be appreciated.


    First combo box


    Please Login or Register  to view this content.


    Second combo box


    Please Login or Register  to view this content.
    Thanks,

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Requery a combo box

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If posting code please use code tags, see here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using Multiple Combo Box Values to populate a cell (Excluding blank combo boxes)
    By mnadamn19 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2016, 08:38 PM
  2. Using Multiple Combo Box Values to populate a cell (Excluding blank combo boxes)
    By mnadamn19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-07-2016, 03:45 PM
  3. [SOLVED] Refresh or Requery Combo Box
    By smugglersblues in forum Access Tables & Databases
    Replies: 1
    Last Post: 09-06-2015, 11:18 AM
  4. [SOLVED] Excel 2010 VBA – Combo Box Options– Clear cell/box in 2nd Combo when 1st Combo selected
    By theshybutterfly in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2013, 07:25 PM
  5. Requery cell with conditional list box
    By LB79 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-17-2013, 05:41 AM
  6. Auto Refresh or Auto ReQuery
    By daylore in forum Excel General
    Replies: 1
    Last Post: 11-03-2008, 06:14 PM
  7. Pivot Table Refresh/Requery
    By yosemite in forum Excel General
    Replies: 1
    Last Post: 04-21-2008, 11:35 PM

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