Two colunms in combo, only store one?

[Bike]

Basically my combo box has two fields values in it.

SELECT [Serial Number] & "" & [Warranty Expiration] FROM
[Information Table];

My question is how would i go about only storing the serial # in the desired field/table and to ignore storing the warranty information.

I have a information table where the serial number is used from, but i want it to be stored when an invoice is filled out and i have a whole different table that keeps track of repairs / invoices.

[pbaldy]

Add the serial number as a separate column in the row source, and make that the bound column of the combo. You can hide it from the user with the column widths property.

[Bike]

Works great, learning more and more everyday ha.

Thanks for all of the help lately!

[pbaldy]

Happy to help!