i have a search button on my form and i need to search all the information inside the "information" table. i have 10 fields.
what i've code is:
adoInfo.RecordSource = "select * from information where name+age+score+birthdate+gender+civilstatus+citizenship+contactnumber+address+email like '%" & txtSearch.Text & "%'" adoInfo.Refresh If adoInfo.Recordset.RecordCount = 0 Then MsgBox "Data Not Found", vbCritical, "Search Result" End if
this code works fine but i want to know if there's a shorter code for this. instead of enumerating the fields to search.. is there a shorter code for "search all fields".