Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

RE: Combo box to filter records in a tabular form

Discussion in 'Information Technology' started by LCSIV, Jul 28, 2006.

  1. LCSIV

    Expand Collapse

    your response looks very close to what I'm trying to do...

    I have a table With Columns A, B, C, (A = Key ID = Text)

    My form is set up as Default View = Single Form.

    I'm trying to set up Two Combo Boxes that filter the records that the form
    is looking at, and then have a third combo box that has the choices filtered
    to = the records available (A) after the filters are turned on

    First thing First...
    Filtering my form with a combo box,
    Here is what I have

    Private Sub B_AfterUpdate()
    If Len(Me.B.Text) = 0 Then
    Me.Filter = ""
    Me.FilterOn = False
    Me.Filter = " = " & Me.B
    Me.FilterOn = True
    End If
    End Sub

    Something is not right with this... An error message comes up and asks me to
    "Enter Parameter Value". Then it shows the value I selected on the dropdown
    list and then has a text box for me to enter text into. If I enter any of
    the values from my list it will filter the records the way I want them to.
    What is wrong in my code that is causing the lost of the “Parameter Value�

    How do you get two of these combo boxes to work together? I need to be able
    to filter by one or the other, and both. (Is it possible to add other combo
    box filters to this string if I had more columns to work with i.e. D, E, F, G)

    How do you get the Wizard generated Record Selecting Combo Box [A] to be
    limited to the records returned from the Filter?

    Thanks for your help
  2. Loading...

Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page