Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Virginia, USA
    Thanked 1 Time in 1 Post

    Search box OnCurrent event (2003)

    I've tried searching for the answer to this question, but so far no luck. I've probably not entered the right criteria. Anyway, I have two comboboxes on a form, each of which allows the user to lookup a particular record. I need both of these boxes to go blank (empty) as soon as the user chooses a record to display.

    I've seen the answer in this forum before, and I know the answer has something to do with the OnCurrent event of the form.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Search box OnCurrent event (2003)

    Try something like this:

    Private Sub Form_Current()
    Me.cboSearch1 = Null
    Me.cboSearch2 = Null
    End Sub

    where cboSearch1 and cboSearch2 are the names of the combo boxes. If their names contain spaces or unusual characters, put square brackets [ ] around the name, e.g.

    Me.[Search Combo Box] = Null

Posting Permissions

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