Creating ComboBox on Access 2000 form
I would like to query the first column of the ComboBox data (Based on another table)but have the corresponding value of the second column data placed into the ComboBox view.
Thanks in advance

On the format tab of the combo property, set the column width to 0";1"

The first column will not show, but the bound column will be column(0), the first column.

I hope that helps.

Hi dcat1,

Thanks for your response.. Although.. I think that I didn't explain my requirement well enough.

When I select the ComboBox drop down arrow, I am wanting to see both of the columns of data. The first column would contain a short three or four letter code and the second column will contain the code description.
I am hoping to be able to type in the code and only have the corresponding description item appear in the ComboBox pane.

Thanks