Combo box to find record - wrong value!

[fraser_lindsay]

Hello,

I have a form and I have added a combo box to quickly find records. I used the wizard to set this up as I did not know the code. Anyway this works, but it displays the wrong value - it displays the ID number and not the text value from the table.

The record source is a table not a query.

What am I doing wrong here, I have tried changing the control source and it doesn't work.

Any suggestions?

 

[RuralGuy]

The ComboBox you described should *not* have a ControlSource! It should be UnBound! Change the ColumnWidths property so you can see the column you want.

 

[fraser_lindsay]

Tried changing that and if it displays both column they both show the same thing - the ID value and not the text value.

Is this because the column I am using as the look up for the combo from the main table looks up the value from a separate table of choices?

 

[RuralGuy]

All the ComboBox can display is a field from it's RowSource!

 

[fraser_lindsay]

But in the table the information is displayed correctly i.e. the text value based on the lookup from the other table.

Why can't the form display the same? It works when displaying the information for that field on each record, but not for this unbound combo.

Anyway around this, all I want to do is quickly jump to a record to make life easier.

 

[RuralGuy]

It sounds like you have a "LookUp" field in your table. Change it to a TextBox and you will see the problem.