Navigation buttob RRS feed

  • Question

  • I have made a form with name frmFrame, and I have a combobox to search for frame, the code is below:

    Private Sub cboFinnFrame_AfterUpdate()

     DoCmd.ApplyFilter , "[tblframe]![Frameid]=Form![frmframe]![cboFinnFrame]"

    End Sub

    When I put the form into a new form with navigation button the filter doesn’t work. The form with navigationbutton is named Receiverdatabase and has NavigationSubform  with to rows with navigation buttons.

    How should the expression bee??

    Tuesday, September 15, 2020 5:36 PM

All replies

  • Try this:

    Private Sub cboFinnFrame_AfterUpdate()
        DoCmd.ApplyFilter , "tblframe!Frameid=" & Me!cboFinnFrame
    End Sub

    Regards, Hans Vogelaar (https://www.eileenslounge.com)

    Tuesday, September 15, 2020 6:34 PM