Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clear Combo Box (Access 2003)

    How do I get a combo box to show nothing when the form is opened. Now if I select something in the combo box - the next time I open the form the combo box still shows the same selection.
    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Clear Combo Box (Access 2003)

    Is the combo box bound to a field in the record source of the form, i.e. does the Control Source of the combo box contain a field name?

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Clear Combo Box (Access 2003)

    Hi Robin

    Is the form you created bound to a table or query?

    If it is an unbound form you can use

    Private Sub Form_Open(Cancel As Integer)
    Me.FieldName = ""
    End Sub

    where FieldName id the name of your combo box
    Jerry

  4. #4
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear Combo Box (Access 2003)

    Thanks Hans - got it working

  5. #5
    Star Lounger
    Join Date
    Sep 2002
    Location
    Edmonton, Alberta
    Posts
    92
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Clear Combo Box (Access 2003)

    Thank you so much - got it working

Posting Permissions

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