it can be done, but depends how flexible it needs to be - how does the app know which fields to apply the criteria to. If it is just two, say StudentName and Level and always in the same order and you are not using lookup fields in your table design you could do something like
Code:
dim I as integer
dim arr() as string
arr=split(txtSearch,",")
sqlStr=SELECT * FROM myTable WHERE StudentName='" & arr(0) & "'"
if ubound(arr)>0 then sqlstr=sqlStr & " AND Level='" & arr(1) & "'"
listbox.rowsource=sqlstr