[AccessD] need help with filter code

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



More information about the AccessD mailing list