Re: How to get matching values with combo box and dropdown property?

From: Wayne Morgan (comprev_gothroughthenewsgroup_at_hotmail.com)
Date: 07/29/04

  • Next message: Chris Mills: "Re: Loop query"
    Date: Thu, 29 Jul 2021 10:03:57 -0500
    

    I just tried the following in a combo box and it appeared to work.

    Private Sub Combo0_Change()
    Me.Combo0.RowSource = "SELECT Test1 FROM Table1 WHERE Test1 Like ""*" &
    Me.Combo0.Text & "*"";"
    End Sub

    -- 
    Wayne Morgan
    MS Access MVP
    "Jack Darsa" <jdarsa@taskir.co.il> wrote in message
    news:u6ueRIXdEHA.2408@tk2msftngp13.phx.gbl...
    > Is there a way to do this without a textbox ?
    > I mean just using the combox and an event or property that does it ?
    

  • Next message: Chris Mills: "Re: Loop query"