Button currently open a new form for records where thefield [Position] has a value of "Staff'
but I need it also to only show records where the field [Inactive] is "true" (0)Code:Private Sub cmdStaffLookup_Click() Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmPeopleList" stLinkCriteria = "[Position]= 'Staff'" DoCmd.OpenForm stDocName, , , stLinkCriteria End Sub
I tried using AND at the end of the stLinkCriteria
but error
any help would be appreciated
tia
dave