Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2005
    Location
    Sydney, New South Wales, Australia
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combobox VB (2002)

    G'day,
    I amusing an unbound combobox to supply values to a SQL string that is then used to filter a form and a report.. It all works for the first combobox!
    When a value has been selected in the first combobox, it creates a SQL string which is applied to the Row Source of a second combobox. That appears to work also.
    When a selection is made by the second combobox, even that works!
    HOWEVER, after selecting a value, the second combobox reverts to displaying the first value in the list.!!!
    I cannot discover which process is triggering this. Please help! Regards, mccer

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Combobox VB (2002)

    dont know what the problem could be.

    can you compact zip your database for us to look at.

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Combobox VB (2002)

    What code do you have behind the second combobox?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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