Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    May 2002
    Location
    Hawaii
    Posts
    69
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ComboBox Clearing (2000/SR-1)

    I have three combo boxes (unbound) on a form, say cbo1, cbo2, and cbo3. The contents of cbo2 depend on the selection in cbo1 and the contents of cbo3 depend on cbo2 using SELECT statements.

    The problem I am running into is when I change selections in either cbo1 or cbo2 after an initial selection. I am unable to clear the items in the selection box of any other dependent combo box. I am able, using the .Requery method, to clear the lists, but cannot find a way to clear the prior selection.

    Any ideas?

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: ComboBox Clearing (2000/SR-1)

    You could use:
    <pre>Me.cbo2 = Null
    Me.cbo3 = Null </pre>

    HTH

Posting Permissions

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