Pedro Janssen
pedro at plex.nl
Tue Feb 17 03:35:01 CST 2004
Hello Group, i have 6 patients fields in which i want to do a search on their names. I don't want to use the existing filter in access, but search with a commandbutton and a textbox. I can use the following code with 6 cmdbuttons and 6 textboxes, but that doesn't work in practice. What i want is one cmdbutton and one txtbox that searches true all 6 fields Can you help me on this? Private sub cmdsearch1_Click() Me.Filter = "qryPatientData.Patient1ID Like'*" & Me.txtboxSearch1 & "*'" Me.FilterOn = True Me.Requery Me.Refresh End Sub