Hi I am in need of some help. I have a code below:
strStoreVdr = "'" & txtFind.Text & "%" & "'"
rsUsrAcc.Find "[vendor_name] like " & strStoreVdr
this works fine but when I come across a text where not much similar the record becomes eof and error. For example user types in 'p' and in my record there is no vendor name starting with 'p' it would become end-of-file and would not load the data. I need it where if there is no 'p' then go to 'q' and so on.
thanks in advance.
strStoreVdr = "'" & txtFind.Text & "%" & "'"
rsUsrAcc.Find "[vendor_name] like " & strStoreVdr
this works fine but when I come across a text where not much similar the record becomes eof and error. For example user types in 'p' and in my record there is no vendor name starting with 'p' it would become end-of-file and would not load the data. I need it where if there is no 'p' then go to 'q' and so on.
thanks in advance.