1. I really only need to move the part value because the rest of it is kind of fluff for reports. It is also stored in the parts table for the relational aspect.

The incomplete table is an imported table from an excel spreadsheet that is emailed to me every day. I dont know if this matters or not, but it is an excel.csv.

The unique things that I need from this are the date, quantity, customer, and part.

date and quantity are easy because they merge right over as numbers. price comes from the parts table, so that is a simple dlookup(except for this little problem.)

On the completed side, the part is a combobox, (customer will be too, and I think the same fix for this will fix that). Otherwise all the other fields will come from Dlookups to the parts table.

The whole problem is this:

incompleteSalesf![part] is a textbox and it needs to move to CompletesalesF![PartName] as a combobox.