Hello, everyone. I am new to this forum and newer to Access. I have created a form that uses a combo box to select a record from a linked table. In this case I am selecting a Vendor from a Vendors table. Once the vendor is selected I use a macro (via a button) to open another form in a datasheet view filtered by a query. When the vendor list is shown from the Vendors table it is sorted alphabetically. However, every time I select a vendor and exit the form (whether I run the macro or not) it overwrites the vendor name of the first sorted record of the vendors table with the Vendor ID number of the Vendor selected. Does anybody have any thoughts on what is causing this? The Vendors table is simple and has two fields, a vendors ID and Vendors Name.