the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Progaming environment: Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010 VB based on my own environment: vb6 sp5 ASP based on my own environment: 5.6 VB-NET based on my own environment started 2007 SQL-2005 based on my own environment started 2008 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
Assuming you already have a onclick event on combo box to show the name in another textbox right? You just need to perform Dlookup in order to return the value of another field basing on the search criteria you provided..
example: textbox1 will reflect the search result from field: File Number, in TableName, searching the Name field for the value matching in Combo box