Hi Guys
I have a listbox with shows Name, login, logout ect. I have a textbox which filters the name using the below method.
Which is fine however I then need to filter (AND) the login, logout ......so kind of like a cascading filert. or could I have a command button with the same effect that will filter what is selected in each text box??
Hope you can help.
I have a listbox with shows Name, login, logout ect. I have a textbox which filters the name using the below method.
Private Sub txtName_AfterUpdate()
Me!lstLogin.RowSource = "SELECT * FROM TblLoginTime Where [EmpName] Like '*" & Me.txtName & "*';"
End Sub
Which is fine however I then need to filter (AND) the login, logout ......so kind of like a cascading filert. or could I have a command button with the same effect that will filter what is selected in each text box??
Hope you can help.
