Yet another filter issue :(

[ducecoop]

Button currently open a new form for records where thefield [Position] has a value of "Staff'

Private Sub cmdStaffLookup_Click()

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmPeopleList"
    
    stLinkCriteria = "[Position]= 'Staff'"

    DoCmd.OpenForm stDocName, , , stLinkCriteria

End Sub

but I need it also to only show records where the field [Inactive] is "true" (0)

I tried using AND at the end of the stLinkCriteria


but error

any help would be appreciated

tia

dave

[pbaldy]

Same as your other one:

stLinkCriteria = "[Position]= 'Staff' And Inactive = 0"

By the way, 0 is False, not True.

[ducecoop]

lol
sometimes I get in my own way.

I had tried exactly what you just gave me and it did not work.
Come to find out I had it on the "Open" event

Thanks much

Dave

[pbaldy]

No problemo.