How to retrieve autonumber from linked SQL table in access form

[iladtp]

I am trying to retrieve the autonumber from a linked SQL table into an Access DB form. I tried the following using another field on the form as the focus:

Private Sub fieldname_AfterUpdate()
Me!fieldname.Value = UCase(Me!fieldname.Value)
Forms!Formname.Requery

This displays the auto number in the Identity Field but then immediately displays the first record in the linked table. I need to redisplay the new record for update in other fields of the record.