Loading Access form with text box using autonumber

[Anekwe]

I'm modifying an Access 2000 database created by a co-worker who is no longer with the organization, and is trying to figure out one part of the program. The database has two tables, tblemployees and tblCorrectiveAc tion. The tblemployees has fields ENAME, UserID, and a few others. TblCorrectiveAc tion has an autonumber field named Corrective Action ID, Originator, OrigDept, DateofCA, and several other fields. Then there is a form that has text boxes bound to Corrective Action ID, Originator, OrigDept, and DateofCA. When the form opens, the program looks for the currentuser (logged-in to the computer) and matches the UserID to print the Originator. Then, it fills in the DateofCA and OrigDept. How does the program look at the autonumber field (Corrective Action ID) and fill in the highest number?

The person is using

Sub AssignName()
If Not IsNull(DLookup("[ENAME]", "tblEmployees", "[UserID] = ... etc as part of initial lookup.
Me!txtOriginator.Text = DLookup("[ENAME]", "tblEmployees", "[UserID] =
more lines ....
End If
End Sub

[NeoPa]

Anekwe,

1. Please remember to use code tags when posting a question (As per REPLY GUIDELINES at the right).
2. Are you asking how generally to do it or are you asking someone to work out how your erstwhile colleague did it in his code?

[NeoPa]

BTW - If it's the latter you're asking then all the (relevant) code would be needed. I had a look at what you posted and you've chopped out some of the important bits :(