Simple Combobox Problem

[ddrew]

I have a Form that I use for editing records that has a combobox with a list of counties in it. The table that feeds the combo has two coloums, IDCounty and County, I have set the combobox to only show one field, with the coloum width of the other set at 0, but when I go back to the main form, the textbox that holds the county field shows the IDCounty rather that the county. Im sure this is simple to rectify but I dont know how!

 

[rainman89]

use combobox.column(1) as the source for the textbox to show the country

 

[ddrew]

The problem is when I look at the table, the table is showing the IDCounty rather than the County and it is from this table that the main form gets its data!

 

[missinglinq]

The table that feeds the combo has two coloums, IDCounty and County

The problem is when I look at the table, the table is showing the IDCounty rather than the County and it is from this table that the main form gets its data!

The table is only showing one of two fields that it supposedly has?

 

[Scooterbug]

Make sure that the column count is set to 2 and the the column widths are set correctly. If you don't want to show in the combo box, set the width to 0.

So for example, in the properties of your combo box, the width would look like this:

0,1"