Thanks for your reply i did exactly as u said
Private Sub Item_No_AfterUpdate()
Me.Item_Name = DLookup("[Item Name]", "YourTableName", "[Item No] = '" & Me.Item_No & "'")
End Sub
but at the time of runniong the form it is giving me run time error what is the problem please tell me
how to...