Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
Private Sub Btn_Search_Click() If Me.LstAnalystName = "(ALL)" Then Me.Frm_Search2.Form.RecordSource = "SELECT * FROM qry_AllData " Else ' Update the record source Me.Frm_Search2.Form.RecordSource = "SELECT * FROM qry_AllData " & BuildFilter End If ' Requery the subform Me.Frm_Search2.Requery End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.