rs.Find - Runtime error "Rowset does not support scrolling backwards

Welcome to TT allyson787. To get the most from this site please read FAQ222-2244.

You should use the open recordset method. I believe the execute method is read and forward only, hence the error. You will have to look that up in the help files.

Good Luck

Assuming employee numbers are unique values, why not tweak the query to:

"SELECT * FROM employee1 WHERE EmpNum = '" & strRec & "'; "

Since there's only the one record for each employee number, that obviates the need for any sort of loop; you just load your controls with the field values & you're off to the races.

And, for the record, part of the problem with your code above is that your loop doesn't iterate- you're beating on the same record over & over. The MoveFirst puts you at the beginning of the recordset, then the Find (probably should use FindNext; it only moves forward through the records) puts you on the employee record. Why the loop in the first place? Provided you put a rsEmp.MoveNext before the Loop statement, all you'd be doing is loading the data for the employee you wanted, then immediately blowing that away with the data for the next employee, which is then blown away by the next, etc. When the dust settled, your form would be displaying the data for the last employee in the recordset. Once the FindNext puts you on target, load the field values & get out.