Combo box problem

[kstuart]

I added a Combo box to one of my forms that selects a record in my table based on a particular field.

I save my changes and open the form and it works fine. I select from the field and it goes to the record.

After this I go back to my form in design view and change the size and text for the combo box. When I save this change and open the form again, the combo box is now showing me the record number and not the contents of the field I selected.

I have deleted and recreated the combo box several times and keep getting the same result.

Any ideas what I am doing wrong????

 

[casey]

How many columns have you got in the combobox?

If you have more than one, then you need to adjust the Column Count and Column Widths on the Properties' Format Tab to display the column that you wish to see and to hide the record number depending on which column it is.

ColumnCount..........2
ColumnWidths.........0";1" (If your record number is the first column and you want to hide it)
BoundColumn=1

ColumnWidths........1";0" (If your record number is the second column and you want to hide it)
BoundColumn=2

 

[kstuart]

Thanks for your answer Casey.

I only have one column in the combo box. I tried changing it to a list box and I am getting the same results.

It works the first time and then when I try to change the size, test, etc of it, I go back to the form and it shows the record number.

This is not the first time I am setting up something like this so I am fairly sure I did it properly.

Any other ideas???

 

[kstuart]

I think I have this one cleared up.

When I create the combo box I select the field header that I want to use. Example - REPORT

When I go into the properties afterwards it shows my field source as follows.

[REPORT].ID

I have no clue as to how this happened but when I change it back, everything seems to be fine.

Thanks