Adding the same equipment ID to record changes value to "15" or similar.

[Dirty_Head]

I have a "Check Out Equipment" form. Pretty simple - there's a combobox to drop down and/or scan a barcode into that pulls up the "EquipmentID" field of my table. So I type/scan/select "001001", fill out the rest of the form: Who checked it out, what date, condition on checkout, etc. My Check Out Equipment button runs 2 very simple macros - 1st "saves record" and appends my Log table. 2nd "requeries" so it clears the form. It does append properly to my table, it does clear the form properly and allow additional entries.



Problem:

When I look at my actual table in datasheet view, it's storing "001001" as "15" over and over again. Cannot figure out why it's changing my value instead of storing it as entered. Maybe my combobox up top should be a textbox?

[Dirty_Head]

I thought I already replied. Yes, it was as simple as putting a text box instead of a combo box. As long as my employees are using the barcode scanner and not just typing gibberish in, this should be fine.