locked
Filter a Continous form RRS feed

  • Question

  • My Combo Box in the Form Header contains my OwnerID Number and OwnerName, My Continuous Form Contains the OwnerID which is the Record source and the text box tbOwnerID. What can I put in my afterupdate of my Combo box to show the same records as OwnerID in my Continuous Form

    Thanks for any Help....Bob

    Saturday, October 9, 2010 11:43 PM

Answers

  • I would think this would work:

    Me.Filter = "OwnerID=" & Me.myCombobox
    Me.FilterOn = True

     


    -Tom. Microsoft Access MVP
    • Marked as answer by TurnipOrange Sunday, October 10, 2010 12:24 AM
    Sunday, October 10, 2010 12:08 AM

All replies

  • I would think this would work:

    Me.Filter = "OwnerID=" & Me.myCombobox
    Me.FilterOn = True

     


    -Tom. Microsoft Access MVP
    • Marked as answer by TurnipOrange Sunday, October 10, 2010 12:24 AM
    Sunday, October 10, 2010 12:08 AM
  • Tom you are a Genius  :) Thanks Bob
    Sunday, October 10, 2010 12:24 AM