how does .find work??

[autoIT]

I am trying to figure out exactly how .find property works. Will it be better to use that the following code. I plan on having a button on a form that will retrieve the latest vacation time remaining based on the employees whose name is the employee names textbox.


x=rs.Fields.Item("Employee Name")
y=rs.Fields.Item("Vacation Remaining")

do
rs.movenext
loop until x=txtEmpName.text

do while x=txtEmpName.text
txtVacaRemain.text=y
loop