Find record to update

[Rick]

I have a form where a user can ADD/Update records. If they click the update icon, the form opens with the recordset showing the first record in the table. Problem is, There are alot of records and if a user needs to update his or hers data i would like them to be able to pull up just theirs. The distinct field is Department Number. Each user has their own department number. I have a button attached to a find macro but i cannot get the "Any part of field" to stay in focus. when the button is clicked it opens the find with the "Whole Field" option selected, this will not work. Can any one suggest a simple or better yet a user friendly way of having the user click a button and then enter their department number and then have that bring up their curren data for modification? Thanks in advance.
PS, Please explain clearly as i am a Novice.

 

[bjackson]

one way to attack your problem
1.why not have a combo box filled with department no's
for the user to select their department
2.place a new command button on your form
the command button wizard will guide you through the steps
to open a form at a particular record,based on the value
of your combo box