Hi All,
I have data in a table that I want to incorporate into a form. I would like to use a combo box that will give me two columns of data. I would like to be able to query the first column (short form codes) but have the data from the second column (long hand version)appear as the output on the form. Any help would be appreciated!

When you use the combo box wizard, select to include both fields, do not hide key.

When you are prompted to choose a field that uniquely identifies the row, choose the long
version.

Then you can use this control's value:
as me.Combo1.value ( no need for .value)