Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Northwind Customer Phone List ? (2k)

    This may seem idiotic, so please accept my apology in advance.

    In the Northwind sample database provided by Microsoft, there is a form ("Customer Phone List") with toggle buttons in the form footer. Clicking on one the toggle buttons filters the items in the detail section of the form. My question is: "How is this filtering happening?". There is no vb code in the event for on click.

    Thanks in advance for your consideration.

    Ken

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

    Re: Northwind Customer Phone List ? (2k)

    There is no On Click code for the individual toggle buttons, but there is an After Update event for the option group that contains the toggle buttons. Each toggle button has been assigned an Option Value, from 1 for the "A" button to 26 for the "Z" button and 27 for the "All" button. When the user clicks a toggle button, the After Update event of the option group occurs, and the value of the option group is the option value of the toggle button that was clicked.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2003
    Location
    Central Florida, USA
    Posts
    505
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Re: Northwind Customer Phone List ? (2k)

    Ahh! I was clicking on the individual "buttons" and looking for an on click event. Once I clicked on the "box" around the controls I found the AfterUpdate and the macro. I was looking for vb code and going crazy.

    THANKS!

Posting Permissions

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