Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: forms (Access 2000/ Windows XP)

    are you passing it as part of an sql string? If so then after you pass the parameters, you can do docmd.close.

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

    Re: forms (Access 2000/ Windows XP)

    You could put a command button on the form that clears the combo boxes:

    Private Sub cmdClear_Click()
    Me.cboCombo1 = Null
    Me.cboCombo2 = Null
    Me.cboCombo3 = Null
    Me.cboCombo4 = Null
    End Sub

    If you displayed a form or report, there would be ways to reset the combo boxes automatically, but with a query, the user will have to initiate it.

  3. #3
    Lounger
    Join Date
    Jul 2005
    Location
    Lancaster, Delaware, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Clearing combo boxes on form (Access 2000)

    Subject edited by HansV to make it more descriptive

    I have a form and on this form there are 4 combo boxes. When the user selects "items" from the combo boxes and then hits a command button these "items" are then passed to a query as parameters. Now when the user closes the query that was performed the form with the combos on it is visible. The question is: Is there a way to reset all of the combos so that nothing is selected? Right now the user after closing the query has to exit the form and then reenter the form so that there will be nothing selected in the combos. Any help is very much appreciated.

  4. #4
    Lounger
    Join Date
    Jul 2005
    Location
    Lancaster, Delaware, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: forms (Access 2000/ Windows XP)

    Thanks Hans this is exactly what I was looking for. I knew there was a simple answer.

  5. #5
    Lounger
    Join Date
    Jul 2005
    Location
    Lancaster, Delaware, USA
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: forms (Access 2000/ Windows XP)

    Thanks Zave for your response but I believe that Hans's suggestion is more suited towards my problem. Thanks again for the response.

Posting Permissions

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