Combo (2000)

Topic

New Reply

Hi, have a combo box that shows both the numeric ID field and the name for the ID (ie. 1 Cakes). I only want cakes to be shown in the combo box but the ID number to be the stored data in the d/b. How do I change any properties to achieve this?

Thanks Darren.

Reply | Quote

Replies

The Row Source of the combo box should return the ID as first column (field), and the name as second column.
Set the Bound Column property to 1 (the default value); this specifies that the first column (the ID) will be stored.
Set the Column Count to 2, and the Column Widths property to 0;1. This tells Access to hide the first column, and only display the second (the name).

Reply | Quote

Thank u Hans for this and my earlier post.

Regards Darren.

Reply | Quote

Thank u Hans for this and my earlier post.

Regards Darren.

Reply | Quote

The Row Source of the combo box should return the ID as first column (field), and the name as second column.
Set the Bound Column property to 1 (the default value); this specifies that the first column (the ID) will be stored.
Set the Column Count to 2, and the Column Widths property to 0;1. This tells Access to hide the first column, and only display the second (the name).

Reply | Quote