I am having an issue when i try to use some alphanumerical data. I have to track some parts by a serial number (ex. a596) so they way i have it set up right now is you first enter the new serial and it will save to table1 as type text. The update info is saved in table2, which is also set as type text. i use a combo box to look up availible serials from table1 and once you finish the update and if you look at table2 all the other data is fine except the serial. The serial appears as an integeter, ex. if i have serial a596 in table1 i get 3 in table2 for the serial. Can anyone help me on this one?!