i have a table emp ( in oracle ) with the following structure : empid number(4); name varchar2(15); i have created a search form to search...

i have a table emp ( in oracle ) with the following structure : empid number(4); name varchar2(15); i have created a search form to search either by empid or name. searching by empid is working fine with this code however searching with the name produces an unsuccessful search. if i remove the condition : "If rs.BOF And rs.EOF Then" then it gives an error "either BOF or EOF is true". although its not the case when i'm searching for an id of the same person. this is the code i'm using. any help would be much appreciated. Private Sub cmdsearch_Click() Dim strid, strname As String connect ' function for the connection If Option1.Value = True Then ' search by empid a = Val(txtsearch.Text) strid = "select * from emp where empid = " & a & " " Conn.Open rs.Open strid, Conn If rs.BOF And rs.EOF Then MsgBox "No such record exists ", , "Search" rs.Close Set rs = Nothing Conn.Close Set Conn = Nothing Exit Sub Else txtempid.Text = rs!empid txtname.Text = rs!Name rs.Close Set rs = Nothing Conn.Close Set Conn = Nothing End If txtsearch.Text = Empty End If If Option2.Value = True Then ' search by name b = txtsearch.Text strname = "select * from emp where name like ' " & b & " ' " Conn.Open rs.Open strname, Conn If rs.BOF And rs.EOF Then MsgBox "No such record exists ", , "Search" rs.Close Set rs = Nothing Conn.Close Set Conn = Nothing Exit Sub Else txtempid.Text = rs!empid txtname.Text = rs!Name rs.Close Set rs